My web host tell me the Database Directory is D:\Inetpub\queerbbs\db So, I upload snitz2000.mdb in that folder "db" Inside config.asp, i change database connection to:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("D:\Inetpub\queerbbs\db\snitz2000.mdb") '## MS Access 2000 using virtual path
But it turns out the error message as belows: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /inc_top.asp, line 51 What can I do? Thanks.
Thanks for your instant reply. After I try your method I got another error message:
Microsoft JET Database Engine error '80004005' Unrecognized database format 'D:\Inetpub\queerbbs\db\snitz2000.mdb'. /inc_top.asp, line 296 . line 296 in inc_top.asp is set rsWho = my_Conn.Execute (strSql) Please help again. Thanks.
But I got the same error message as above. Another thing I have to point out is I used to host on 121host.net, which is very easy to set up, but the server is not quite reliable. So I try to switch to cihost.com. So, the database(snitz2000.mdb) got some data already. Will it be a problem? Thanks again.
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Inetpub\queerbbs\db\snitz2000.mdb;" '## MS Access 2000
Thank Richard Kinser, The one above works great. The reason that I got another error message is because I don't have permission for to that database account. I have asked my web host to change it. It's working now. Thank you again.
Topic Locked
Posted - 11 May 2001 : 20:25:36
