ADODB.Connection error ' 800a0e7a'

Results 1 to 2 of 2

Thread: ADODB.Connection error ' 800a0e7a'

  1. #1
    Najim el Mouridi Guest

    Default ADODB.Connection error ' 800a0e7a'

    Hello everyone,<BR><BR>After having the following error while trying to connect to a access<BR>database I have tryed several ways to fix this problem.<BR><BR># uninstalled option pack 4 + reboot<BR># cleaned registry + reboot<BR># installed option pack 4 + reboot<BR># installed mdac(ado update 2.1) + reboot<BR># checked all permissions to the database<BR><BR>After all this I still get this error.<BR><BR>++++++++++++++++++++++++++++++++++++ ++++++++<BR>ADODB.Connection error &#039 800a0e7a&#039<BR><BR>ADO could not find the specified provider.<BR><BR>/home/nieuws.asp, line 13<BR>++++++++++++++++++++++++++++++++++++++++++++ <BR><BR>The script looks like this:<BR><BR>sql = "SELECT TOP 15 TBL_nieuws.* FROM TBL_nieuws WHERE body Is Not Null<BR>order by Datum desc"<BR>test = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:
    ieuws.mdb"<BR><BR>&#039 Open connection ------------------------------------------------------<BR>Set cn = Server.CreateObject("ADODB.Connection")<BR>Set rs = Server.CreateObject("ADODB.Recordset")<BR>cn.Open test<BR><BR>Could any one shed a light on this problem?<BR><BR>Many thanks,<BR><BR>Najim<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: ADODB.Connection error ' 800a0e7a'

    When making connection strings, always, always, always use the tips suggested at this article:<BR><BR>A Nifty Way to Create Connection Strings<BR>http://www.4guysfromrolla.com/webtech/070699-1.shtml<BR><BR>When you make connection strings via this method, you are guaranteed to create a usable connection string on your machine! :-)

Posting Permissions

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