-
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
-
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:
Code:
myRec.CursorLocation = adUseClient
myRec.Open "select * from pwdexport where ...", myconn, adOpenKeyset, adLockOptimistic, adCmdText
[Edited by Mongo on 07-13-2000 at 12:43 AM]
