OLEDB Connection Error

Results 1 to 3 of 3

Thread: OLEDB Connection Error

  1. #1
    Tenbroeck Guest

    Default OLEDB Connection Error

    I get an error when trying to connect to my Access &#039 97 database using a DSN-less, OLEDB connection. <BR>Here&#039s the OLEDB ConnectionString:<BR>"Provider=Microsoft.Jet.OLEDB .3.51; Data Source=D:AFDCAFDCMembrshp.mdb" <BR>Here&#039s the error:<BR>ADODB.Connection error &#039 800a0e7a&#039 Provider cannot be found. It may not be properly installed. <BR><BR>I just installed the latest MDAC (2.5). Before that the DSN-less ODBC connection didn&#039t work either, but now that works. Where do I look next?<BR><BR>TIA for any help. <BR><BR>PS. When I use this DSN-less ODBC ConnectionString it works:<BR>"Driver={Microsoft Access Driver (*.mdb)}; DBQ=D:AFDCAFDCMembrshp.mdb"<BR><BR><BR><BR><BR><BR >

  2. #2
    SPG Guest

    Default RE: OLEDB Connection Error

    Funny, but I could swear that the Jet engine for MDAC 2.5 is 4.0, not 3.51...<BR><BR>Just a guess.

  3. #3
    Tenbroeck Guest

    Default RE: OLEDB Connection Error

    That was it, installing MDAC 2.5 upgraded me to Jet 4.0. Thanx.<BR>

Posting Permissions

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