Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[eljacobs]

Hi there

i've got a problem that just won't go away!!

I've created a simple site linked to an access database. It works fine on my machine (when i can get iis to work properly but that's a different matter!) but when i upload it to the host's server i get this message:

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.

/index.asp, line 8

I've changed the path to the database so that it references the databse on the server.

Any ideas?

Any advice is much appreciated.

Regards

Elliot

 

[FesterSXS]

Have you double and triple checked that the path is correct? Also you will need to assign write permission to the database and its folder for the IUSR account.

Tony

http://www.SpiraxSarco.com

 

[medic]

FesterSXS is right. And if you placed your MDB file in the same folder where your ASP file resides, you may try modifying your connection string to make it look something like this:

ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
          "Data Source=" & server.mappath(".") & "\MyDB.mdb;"

(assuming the name of your database is MyDB.mdb)

 

[medic]

Hmmm...I got used to "folder only" databases. A more simple code should be:

ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
          "Data Source=" & server.mappath("MyDB.mdb")