Connection Errors

Discussion in 'C#' started by devmonk, Oct 23, 2006.

0
  1. #1
    I am getting a 800a0e7a error from my dsn-less connection. I am trying to connect to an access database on the windows 2003 server where the site is hosted. The server has MDAC 2.8 installed. I tried to install the Jet 4.0 service pack 8 but it said that what was installed was newer than this update.

    Here is my connection string...

    <%
    Dim conn
    Set conn=Server.CreateObject("ADODB.Connection")
    conn.Open("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & server.mappath("/faultlessDB.mdb") & ";")
    %>

    Anyone know what I need to do? I have searched google and other forums and they all said I need to update to the latest MDAC but that did not work. Other Ideas?

    Thanks,

    Jason
     
    devmonk, Oct 23, 2006 IP
  2. 50plus

    50plus Guest

    Messages:
    234
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Try this and see if you have any more luck, it works for me :

    Dbase = Server.MapPath("/faultlessDB.mdb")
    conn= "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Dbase & ";"

    Set conn=Server.CreateObject("ADODB.Connection")
     
    50plus, Oct 23, 2006 IP
  3. Ronal

    Ronal Peon

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Hello,

    once try this.......
    Set cn = Server.CreateObject("ADODB.Connection")
    cn.Open "Provider=SQLOLEDB.1; Network Library=dbmssocn;Password=5pq2dkmnzj;User ID=user1128243;Initial Catalog=kitinccom;Data Source=ipsqtw0024atl2.registeredsite.com;"

    Regards
     
    Ronal, Oct 26, 2006 IP