Dear All,

I'm trying to use DSN-less Connection, and I use SQLOLEDB.

My Open Connection Syntax :

myConn.Open "Provider=SQLOLEDB; Data Source=server name; Initial Catalog=database name; User ID=username; Password=password"

Well, my statement run well. But, when I try to use it on recordset, and when I want to update my record, an error occured (The Operation requested by the application is not supported by the provider)

My Record Syntax :


myRec.Open "select * from pwdexport where ...", myconn, adOpenDynamic, adLockOptimistic, adCmdText

myDate=Date()
myRec!last_on=myDate
myRec!Used='Y"

myRec.Update

myRec.Close


When my code run at myrec!last_on=myDate, the error occured.

Could anybody help me please ASAP ???

Thx a lot for any kinda help.
Regards,

Wen Lie