Database Connection Error

Results 1 to 4 of 4

Thread: Database Connection Error

  1. #1
    sparc Guest

    Default Database Connection Error

    Hi,<BR>I&#039;m having trouble connecting to my Access database. Here is the error:<BR><BR>ADODB.Connection.1 error &#039;80004005&#039; <BR><BR>SQLState: 01000<BR>Native Error Code: 0<BR>SQLState: S1000<BR>Native Error Code: -12930<BR>[INTERSOLV][ODBC SequeLink driver][SequeLink Client]Connection network error R-12930 occured<BR>[INTERSOLV][ODBC SequeLink driver]An unknown value has been specified for DataDictionary.<BR><BR><BR>/test.asp, line 3 <BR><BR><BR>this is my ASP script:<BR><BR>&#060;%<BR>Set Conn = Server.CreateObject("ADODB.Connection")<BR>Conn.Op en "DSN=EmpowerTeam"<BR><BR>Set RS=Conn.execute("SELECT name FROM mytable")<BR><BR>response.write(RS("name"))<BR><BR >Conn.Close<BR>Set Conn = Nothing<BR>%&#062;<BR><BR>I&#039;m sure that i&#039;ve set the database up properly, so I&#039;ve got no idea what is wrong.<BR>Any help would be very much appriciated<BR><BR>

  2. #2
    Martin Guest

    Default RE: Database Connection Error

    Ok, maybe you&#039;ve made an error for the database connection. Try this one:<BR>&#060;%<BR>Set Conn = Server.CreateObject("ADODB.Connection")<BR>Conn.Op en "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.Mappath("location_and_name_of_your_db.mdb") <BR><BR><BR>Set RS = Conn.Execute("SELECT name FROM mytable") <BR><BR>response.write(&#060;%= RS.Fields("name").Value %&#062;) <BR><BR>Conn.Close <BR>Set Conn = Nothing <BR>%&#062; <BR><BR>

  3. #3
    Martin Guest

    Default Tell me

    Please tell me if this worked. Thank you

  4. #4
    sparc Guest

    Default RE: Database Connection Error

    I need to use a DSN for my database<BR>It was working before but now I get that error. I tried making a new database but i still get it.

Posting Permissions

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