rmidaho
asked on
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Here is the full error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/source/AirMulti.asp, line 162
The error started after I had copied the Access database from the web server, made some changes to the DB and then copied it back up to the server.
Server = Windows Server 2003
IIS 6.0
Access DB file
Again, it is assumed that the connection worked prior to me updating the database and the error started with that act.
I have checked the permissions bot at the file level and within IIS to be sure the web account can open and read the database.
Hopefully someone out there can lead me to the correct solution. None of the answers given in my search has worked.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/source/AirMulti.asp, line 162
The error started after I had copied the Access database from the web server, made some changes to the DB and then copied it back up to the server.
Server = Windows Server 2003
IIS 6.0
Access DB file
Again, it is assumed that the connection worked prior to me updating the database and the error started with that act.
I have checked the permissions bot at the file level and within IIS to be sure the web account can open and read the database.
Hopefully someone out there can lead me to the correct solution. None of the answers given in my search has worked.
Dave Baldwin
On my machine, 'mdb's always required write permission to be accessed. open and read aren't enough. Would get an error otherwise.
The file may be blocked. It happens when file comes from the web.
right click on the mdb file, then properties, then select the button "Unblock".
Check:
http://stackoverflow.com/questions/135600/reproducing-the-blocked-exe-unblock-option-in-file-properties-in-windows-2003
right click on the mdb file, then properties, then select the button "Unblock".
Check:
http://stackoverflow.com/questions/135600/reproducing-the-blocked-exe-unblock-option-in-file-properties-in-windows-2003
ASKER
DaveBaldwin, Added the write permision. No change. Thanks
ASKER
mas_oz2003: If there is an "Unblock" button in the MDB file properties, it is hidden to me. Thanks for the help but unless you can lead the blind this did not help.
My ASP/mdb connections all use an absolute path like this:
' Create ADO Connection Component to connect to database
Set oConn = Server.CreateObject("ADODB
oConn.Open "Provider=Microsoft.Jet.OL
' Create ADO Connection Component to connect to database
Set oConn = Server.CreateObject("ADODB
oConn.Open "Provider=Microsoft.Jet.OL
Wondering about the path to the db, how is it defined in your connection properties?
Does Server.MapPath("./expected
Alan
Does Server.MapPath("./expected
Alan
Unblock button is located at the bottom of General tab in the File Properties window of the mdb file.
At the bottom, You should see the following message:
"This file came from another computer and might be blocked to help protect this computer."
If you do not see the button, you can "unblock" files using "AlternateStreamView " or "Streams CLI executable", for steps check:
http://superuser.com/questions/38476/this-file-came-from-another-computer-how-can-i-unblock-all-the-files-in-a
At the bottom, You should see the following message:
"This file came from another computer and might be blocked to help protect this computer."
If you do not see the button, you can "unblock" files using "AlternateStreamView " or "Streams CLI executable", for steps check:
http://superuser.com/questions/38476/this-file-came-from-another-computer-how-can-i-unblock-all-the-files-in-a
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
While the offered suggestions did not lead to a resolution they did help this novice understand how IIS works and how to link it to a database. They helped me feel more comfortable in taking the actions I did that corrected the issue