Whats this error 1

[SteveD73]

Hi

When I try and run my asp page it gives me this error:

ADODB.Recordset error '800a0cb3'

Object or provider is not capable of performing requested operation.

/registeruser.asp, line 27

Line 27 is

objRS("clientName&quot = "Client"

Ive also tried

objRS.Fields("clientName&quot = "Client"

Any ideas?

Thanks

 

[shaddow]

Try to use These constants and this example for acess:

Set Connection=Server.CreateObject("ADODB.Connection&quot
dbPath=Server.MapPath("clients.mdb&quot
Connection.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&dbPath

Const adOpenStatic = 3
Const adUseClient = 3
Const adLockPessimistic = 2

set rs=server.CreateObject("ADODB.Recordset&quot

sub ExecuteSQL(byval cmd)
if rs.State=1 then rs.Close
rs.CursorType = adOpenStatic
rs.CursorLocation = adUseClient
rs.LockType = adLockPessimistic
rs.Source = cmd
rs.ActiveConnection = Connection 'The record set needs to know what connection to use.
rs.Open
end sub
________
George, M
email : shaddow11_ro@yahoo.com

 

[SteveD73]

Thanks for the reply.

I have tried this:

Set Connection=Server.CreateObject("ADODB.Connection&quot
dbPath=Server.MapPath("users.mdb&quot
Connection.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&dbPath

Const adOpenStatic = 3
Const adUseClient = 3
Const adLockPessimistic = 2

set rs=server.CreateObject("ADODB.Recordset&quot
ExecuteSQL("UPDATE users SET clientName = 'CLIENTTEST'&quot

sub ExecuteSQL(byval cmd)
if rs.State=1 then rs.Close
rs.CursorType = adOpenStatic
rs.CursorLocation = adUseClient
rs.LockType = adLockPessimistic
rs.Source = cmd
rs.ActiveConnection = Connection 'The record set needs to know what connection to use.
rs.Open
end sub

But now I get this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/test.asp, line 27

Any help is appreciated.

Thanks

 

[GDX]

Operation must use an updateable query.

This means that the database your writing to doesnt have write access so you have to give access to the ISUR_<Computer name> account within the ACL. I hope this helps. Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371