asked on

ODBC driver does not support the requested properties

This should be fun. I am trying to help someone set up a database. They downloaded this program. Now when they try to access it online, they get this message: ODBC driver does not support the requested properties. And the line that it is calling is:
RS3.Open GeneratedSQL,Conn3,adOpenKeyset,adLockReadOnly 'both keys are to be variables

Using MS Access 2000 - maybe it just needs to be updated? Thanks!

-Corey

Saqib Khan

what are you doing with the GeneratedSQL Script?
is it a insert statement?
if yes then use
Conn3.open GeneratedSQL

Its a Server Side Error. Not your Side.

Gary

You're using ODBC? Try using OLE...
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("db.mdb") & ";Jet OLEDB:Database Password="

coreybryant

ASKER

adilkham when I changed it to: RS3.Conn3.open GeneratedSQL,adOpenKeyset,adLockReadOnly, I received this error: Object doesn't support this property or method: 'RS3.Conn3'

GaryC123 - I have no idea. This program that she bought seems to have have a bunch of problems. Right now, it seems it is:
DataSource3 = "Driver={Microsoft Access Driver (*.mdb)}; DBQ= "& DB_Path &"WebStore/Databases/ShopDB.mdb;"
Apparently there are quite a few different connections that it is trying to establish

Here are some more lines above:
Set Conn3 = Server.CreateObject("ADODB.Connection")
Set RS3 = Server.CreateObject("ADODB.RecordSet")
RS3.CursorType = adOpenStatic
Conn3.Open DataSource3
RS3.Open GeneratedSQL,Conn3,adOpenKeyset,adLockReadOnly 'both keys are to be variables
Conn3.Close
set rs3 = nothing
set Conn3 = nothing

-Corey

Gary

Definitely change to the connection string i mention earlier

DataSource3 ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DB_Path &"WebStore/Databases/ShopDB.mdb;"

SOLUTION

Saqib Khan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

coreybryant

ASKER

GaryC123, when I used your, I get: Operation must use an updateable query (for RS3.Open GeneratedSQL,Conn3,adOpenKeyset,adLockReadOnly)

adilkhan, when I inputted: RS3.Conn3.execute(GeneratedSQL),adOpenKeyset,adLockReadOnly - the error was: Object doesn't support this property or method: 'RS3.Conn3'

-Corey

Gary

RS3.Open GeneratedSQL,Conn3,2,2

coreybryant

ASKER

GaryC123, using: RS3.Open GeneratedSQL,Conn3,2,2, this is the message: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query
-Corey

ASKER CERTIFIED SOLUTION

Gary

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

coreybryant

ASKER

Hm, well it does the folder does have read/write for anonymous settings. Is that what you mean?

-Corey

coreybryant

ASKER

I actually chose secure read-write & that worked. I also left the changes the way we have talked about. I wil change them back to check - (there are too many places in this program to change it) :-/

Thanks!

Corey