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
LVL 29
coreybryantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saqib KhanSenior DeveloperCommented:
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.
0
GaryCommented:
You're using ODBC?  Try using OLE...
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("db.mdb") & ";Jet OLEDB:Database Password="
0
coreybryantAuthor Commented:
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
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

GaryCommented:
Definitely change to the connection string i mention earlier

DataSource3 ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DB_Path &"WebStore/Databases/ShopDB.mdb;"
0
Saqib KhanSenior DeveloperCommented:
I am sorry i mean change it to this

Conn3.execute(GeneratedSQL)
0
coreybryantAuthor Commented:
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
0
GaryCommented:
RS3.Open GeneratedSQL,Conn3,2,2
0
coreybryantAuthor Commented:
GaryC123, using: RS3.Open GeneratedSQL,Conn3,2,2, this is the message:  [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query
-Corey
0
GaryCommented:
Make sure the IUSR account has write permissions on the folder where the db resides - the error means the db/folder is read only so when you try to update or insert a record you get the above error.
Right click the folder, Properties, Security tab, and select the IUSR account or whatever account name you use and set write permissions
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
coreybryantAuthor Commented:
Hm, well it does the folder does have read/write for anonymous settings.  Is that what you mean?  

-Corey
0
coreybryantAuthor Commented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.