**Help Please **ADODB.Connection error '800a0

Results 1 to 2 of 2

Thread: **Help Please **ADODB.Connection error '800a0

  1. #1
    J Guest

    Default **Help Please **ADODB.Connection error '800a0

    Hi Guys!! i am getting this below error, any ideas on how to fix this???<BR>This is the error---&#062;<BR><BR>ADODB.Connection error &#039;800a0e7a&#039; <BR><BR>Provider cannot be found. It may not be properly installed. <BR><BR>/pearlhunter/forums.asp, line 23 <BR><BR><BR>This is some code before line 23 & line 23 itself --&#062;<BR><BR>&#039;set up an SQl statement<BR>dim strSQL<BR>strSQL = "SELECT * FROM members WHERE ([members.username]=&#039;" & Request.cookies("pearlhunter") & "&#039;);"<BR>&#039;open an ADO connectiom<BR>Set ConnObj = Server.CreateObject("ADODB.Connection")<BR>&#039;o pen the connection object<BR>(line23)ConnObj.open "Provider=Microsoft.Jet.OLEDB.4.0;" & _<BR>"Data Source=&#039;C:pearlhunterdatabasepearlhunter.mdb& #039;"

  2. #2
    Join Date
    Dec 1969

    Default RE: **Help Please **ADODB.Connection error '8

    It could be that you don&#039;t need &#039;&#039; on either side of you Data Source argument. Try this:<BR><BR>ConnObj.open "Provider=Microsoft.Jet.OLEDB.4.0;" & _<BR>"Data Source=C:pearlhunterdatabasepearlhunter.mdb"<BR><B R><BR>If that doesn&#039;t work then time to upgrade MDAC methinks.<BR><BR>In the meantime, you could try using either the previous OLEDB provider for Access or the MS-Access driver...<BR><BR>OLEDB<BR>-----<BR>dbString = "Provider=Microsoft.Jet.OLEDB.3.5;" & _<BR> "Data Source=C:pearlhunterdatabasepearlhunter.mdb"<BR><B R>MS-ACCESS DRIVER<BR>----------------<BR>dbString = "Driver={Microsoft Access Driver (*.mdb)};" & _<BR> "DBQ=C:pearlhunterdatabasepearlhunter.mdb"

Posting Permissions

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