About SQLOLEDB... Helppppp

[Wen Lie]

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

[Mongo]

By chance, Annyong Hashimnikka?

I do not think CursorType=adOpenDynamic and LockType=adLockOptimistic is supported, so ADO has degraded you to a supported non-updateable CursorType-LockType. That or ADO is confused about it's record location...

Let me know if this works:

myRec.CursorLocation = adUseClient    
myRec.Open "select * from pwdexport where ...", myconn, adOpenKeyset, adLockOptimistic, adCmdText

[Edited by Mongo on 07-13-2000 at 12:43 AM]