1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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