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")

  Dim strConn, strRecordName
  strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  "Data Source=C:\Inetpub\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.

Shouldn't you be using 'DSN=dbdata' to open the database?

-----Original Message-----
From: Tom Devins [mailto:tdev01@y...] 
Sent: Thursday, March 28, 2002 1:31 PM
To: Access ASP
Subject: [access_asp] ADODB.Recordset error '800a0e7a'

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")

  Dim strConn, strRecordName
  strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  "Data Source=C:\Inetpub\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.