ASP: ODBC error 80004005
nemesis @ Tuesday 2nd December, 2003
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Text Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xbdc Thread 0xcd8 DBC 0x2280f64 Text'.
Check:
Are you using a CSV file for a data source?
The ConnectionString should point to the directory; NOT the CSV file! I.e.:
ConnectionString = "DRIVER={Microsoft Text Driver (*.txt;
*.csv)};DBQ=" & Server.MapPath(".")
Does the file exist?
ODBC will throw up this error if the database you're referencing doesn't exist. Did you make a typo on the connection string?
Check there's a \ before the filename, i.e.:
ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="
& Server.MapPath(".") & "\db1.mdb"
(notice the \ before db1.mdb)
Check:
File permissions
ODBC threw me this error when the permissions on the file wouldn't let the webserver user (IUSR) write to the file in an UPDATE query.
Sign in to leave a comment!
Don't have a login yet? Get one now!