ADO Connection to Access ERROR

Results 1 to 2 of 2

Thread: ADO Connection to Access ERROR

  1. #1
    Yeow Loye Guest

    Default ADO Connection to Access ERROR

    I have been using the DSNless connection method to an Access DB on Personal Web Server and everything was OK. When I port the scripts to an IIS 4, the following error message appears;<BR><BR>////////////////////////////////////////////////////////<BR>ADODB.Connection error &#039 800a0e7a&#039 <BR>ADO could not find the specified provider. <BR>////////////////////////////////////////////////////////<BR><BR>Please help.... Following is the connection script;<BR><BR>////////////////////////////////////////////////////////<BR>Dim StrConnect<BR><BR>&#039 Database connection string.<BR>strConnect = "DBQ=" & server.mappath("webDB/mfgitDB.mdb") & ";DefaultDir=" & server.mappath("webDB") & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;"<BR><BR>Dim objConn<BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR>objConn .ConnectionString = strConnect<BR>objConn.Open<BR>////////////////////////////////////////////////////////

  2. #2
    Join Date
    Dec 1969

    Default RE: ADO Connection to Access ERROR

    Have you tried downloading and installing the latest MDAC from Microsoft?<BR><BR>HTH<BR><BR>Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts