ADODB.Recordset error '800a0e7a' - works locally but not online

[tdev]

Hi,

I've been developing some asp pages locally and everything works as it should. However, when I've uploaded the pages to the server I get this error - ADODB.Recordset error '800a0e7a'.

I emailed my server admin and he said he set up a DSN called "dbdata". However, I'm not using a DSN connection (which is ok for this server) but shouldn't the scripts work online as long as the System Access driver for the specific database has been setup?

My code and the specific error is as follows:

************************************************************************
Dim objRS
set objRS = Server.CreateObject("ADODB.Recordset&quot

Dim strConn, strRecordName
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Inetpub\

http://wwwroot\my_folder\dstores\my_database.mdb;"

& _
"Persist Security Info=False"

objRS.Open "table1", strConn, adOpenDynamic, adLockOptimistic, adCmdTable
**************************************************************************
Here is the Specific Error:
ADODB.Recordset error '800a0e7a'

ADO could not find the specified provider.

/my_folder/admin/insert_2db.asp, line 25
**************************************************************************

Any advice, suggestions, help would be very much appreciated.

Thanks for your time.

 

[jonscott8]

As your error states, the Jet 4.0 Provider is missing from or improperly registered on your server.

Tell your Sys Admin to upgrade his MDAC. Jon Hawkins

 

[MikeT]

It seems to me your code is pointing to the physical location of the database on YOUR hard drive:
Data Source=C:\Inetpub\

http://wwwroot\my_folder\dstores\my_database.mdb

Chances are the folder structure on the server is completely different. Try using the DSN he setup for you:
set rs = server.createobject("adodb.recordset&quot
sql="SELECT * FROM myTable"
rs.open sql,"DSN=dbdata"