thunderain
Programmer
Hi:
I am trying to put my asp program on a web server and trying to call up an access database. Should be simple. I have done several on my hard drive, works fine. I need to have it work on a web page. I called the server and they said i need a dsn less code hookup. Went on google found one but not working.
Here is the code I have:
set cnn = server.createobject("ADODB.Connection"
cnn.open "DRIVER={Microsoft Access Driver(*.mdb)};DBQ=c:\test\testDB.mdb"
Here is the error I get:
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. /test/dsn.asp, line 6
line 6 is the second line above starting with cnn.open....
I'm not sure if its just a path problem. On the server, the database is on the same level as the asp program, in a file called test.
Any help would be apprecieted
Thanx
Thunderain
I am trying to put my asp program on a web server and trying to call up an access database. Should be simple. I have done several on my hard drive, works fine. I need to have it work on a web page. I called the server and they said i need a dsn less code hookup. Went on google found one but not working.
Here is the code I have:
set cnn = server.createobject("ADODB.Connection"
cnn.open "DRIVER={Microsoft Access Driver(*.mdb)};DBQ=c:\test\testDB.mdb"
Here is the error I get:
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. /test/dsn.asp, line 6
line 6 is the second line above starting with cnn.open....
I'm not sure if its just a path problem. On the server, the database is on the same level as the asp program, in a file called test.
Any help would be apprecieted
Thanx
Thunderain