Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ODBC driver does not support the requested properties

Posted on 2003-11-26
11
Medium Priority
?
5,488 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:coreybryant
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 2
11 Comments
 
LVL 23

Expert Comment

by:Saqib Khan
ID: 9828060
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
 
LVL 58

Expert Comment

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

Author Comment

by:coreybryant
ID: 9828141
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 58

Expert Comment

by:Gary
ID: 9828156
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
 
LVL 23

Assisted Solution

by:Saqib Khan
Saqib Khan earned 400 total points
ID: 9828165
I am sorry i mean change it to this

Conn3.execute(GeneratedSQL)
0
 
LVL 29

Author Comment

by:coreybryant
ID: 9828250
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
 
LVL 58

Expert Comment

by:Gary
ID: 9828294
RS3.Open GeneratedSQL,Conn3,2,2
0
 
LVL 29

Author Comment

by:coreybryant
ID: 9828323
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
 
LVL 58

Accepted Solution

by:
Gary earned 1600 total points
ID: 9828410
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
 
LVL 29

Author Comment

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

-Corey
0
 
LVL 29

Author Comment

by:coreybryant
ID: 9828436
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

Featured Post

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question