Problem with DATABASE conn.

Results 1 to 2 of 2

Thread: Problem with DATABASE conn.

  1. #1
    kloptra Guest

    Default Problem with DATABASE conn.

    Hi, there is something wrong with my databasse connection but I don&#039t now what? Can anyone help me?<BR><BR>the conn:<BR><BR>&#060;%<BR>Set MinCon = Server.CreateObject("ADODB.Connection")<BR>Set rs = Server.CreateObject("ADODB.Recordset")<BR>MinCon.o pen "DBQ=" & Server.Mappath("/database/car.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"<BR><BR>SQL = "SELECT * From Observationer"<BR>rs.Open SQL, MinCon<BR>%&#062;<BR><BR>AND THE WRONG MESSAGE:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Cannot open database &#039(unknown)&#039. It may not be a database that your application recognizes, or the file may be corrupt. <BR><BR>/cars.asp, line 12 <BR><BR>Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Problem with DATABASE conn.

    Try it this way then you can do <BR>the message is saying it can&#039t find the mdb file in the location specified<BR><BR>connStr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & <BR>Server.MapPath("/database/car.mdb") <BR><BR>&#039Response.write connStr<BR>&#039Response.end<BR>&#039to check the path<BR><BR>MinCon.Open connStr

Posting Permissions

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