Problems with DSNless connection

Results 1 to 3 of 3

Thread: Problems with DSNless connection

  1. #1
    Join Date
    Dec 1969

    Default Problems with DSNless connection

    I am having problem with my DSNless connection. Everything works fine on my personal web server, but when I post to a live server, I get an error.<BR><BR>Here is the code for my DSNless connection:<BR><BR>set dbconnect = Server.CreateObject("ADODB.Connection")<BR>set dbrecord = Server.CreateObject("ADODB.RecordSet")<BR>dbconnec t.Open "driver={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("caproz.mdb")<BR><BR >The DB is in the same folder(flowers) along with all the other files.<BR><BR>Here is the error, I get on a live server:<BR><BR>ADODB.Connection error &#039 800a0e7a&#039 <BR><BR>ADO could not find the specified provider. <BR><BR>/aplogon/flowers/catalogue.asp, line 33 <BR><BR>Can anyone help! THANKS!<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Problems with DSNless connection

    I hope you are declaring the variables first<BR>dim dbconnect<BR>dim dbrecord<BR>Are you?

  3. #3
    harish Guest

    Default RE: Problems with DSNless connection

    strConnect = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=Yourpath<BR>DId you try like this???<BR>ANy Luck??<BR>Harish H

Posting Permissions

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