Microsoft OLE DB Provider for ODBC Drivers error'80004005'

HELP!!!

I faced a problem that is cannot access to Microsoft ACCESS database. I had build up the DSN with the name = Shermont and actual name of .MDB file is Shermont.mdb, I had follow the hosting instruction which is create a new folder named “database” and put same level with the HTML folder and paste my Ms ACCESS database into the folder, but still not work.

This is the code I used to access to the database:
Dim con, rs, str
set con=server.CreateObject("ADODB.CONNECTION")
con.Open "Shermont"
set rs=server.CreateObject("ADODB.RECORDSET")
rs.ActiveConnection=con
str="SQL statement"
rs.open str
…….
rs.close
con.close

Error type:

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.

THANK YOU VERY MUCH.

Try going back to the system and user DSN and select another
MS Access Driver

after finish doing so .. there is abutton by which you can test the connection to the Data Source if the test went good

then you ave a problem with your code or web-server configuration


hope that helps

I can run on my own pc . i think the problem is the web-server configuration . I just want to know that any other way to connect to my database by not go through the web-server dsn ?i has also tried the server.mappath("") method, its still not work.

anyway, thanks for your help, miro

Yes - you can connect to any database using a DSN-less connection. They are quicker and easier to setup than a DSN conn. And great for when you don't have access to the server.

4guys has some great articles on dsn-less connections.

See my post here (the last one) for the URL's to their articles.