ODBC Error

[blondebier]

Any ideas why I would be receiving this error?

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x714 Thread 0x808 DBC 0x1044044 Jet'.
C:\INETPUB\

http://WWWROOT\ADMIN\../db.asp,

line 10

I changed the path in my db.asp file from:

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\inetpub\

http://wwwroot\myDB.mdb;"

& _
"Persist Security Info=False"

to:

dim db
dim strConn

strConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("myDB.mdb&quot

This sorted out another error message, but created this one!

Any help would be greatly appreciated.

 

[mumbojumbo]

location problem.

ooooooooooooooooooooooooh bugger.

 

[onpnt]

two kinds of drivers. you are probably running a newer version of access and some of the older versions do not like the ODBC. besides it's prone to errors and not a suggested connection string anyhow.

____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924[/sub]

http://www.onpntwebdesigns.com

 

[JamesLean]

If I were you, I would go back to using the OLEDB provider and tell us what error you were getting with that. It will probably be easier to fix.

--James

 

[karsh44]

i agree with JamesLean. I had the exact same problem, only I started with your current string and fixed it by changing to your first string. It is easier to fix the first error (whatever it was) than to fix your current error

 

[onpnt]

1) your question to the second thread you started is in my reply
2) please don't start multiple threads on the same topic and problem/discussion etc....
3) in case the answer is somehow hidden in my reply,
The OLEDB is a more stable and less prone to errors connection string!
In case ou want a second opinion, just about every hit from a search will tell you that also.

http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=dsn-less+connection+string+access+asp

http://www.learnasp.com/learn/dbopen.asp

____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924[/sub]

http://www.onpntwebdesigns.com