DB Connection Help

Results 1 to 2 of 2

Thread: DB Connection Help

  1. #1
    Join Date
    Dec 1969

    Default DB Connection Help

    I am just getting back into ASP, and i&#039;m running into issues (being as rusty as i am hah).<BR>I know i&#039;m using incorrect syntax here somewhere, but i can&#039;t figure it out. Take a look plase:<BR><BR>Code:<BR><BR>&#060;%@LANGUAGE="VBSCR IPT" CODEPAGE="1252"%&#062;<BR>&#060;% Option Explicit %&#062;<BR>&#060;%<BR>Dim dbCon<BR>Set dbCon = Server.CreateObject("ADODB.Connection")<BR>dbCon.O pen("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:Inetpubwwwrootdatabase odo.mdb")<BR><BR>Dim getTask<BR>Set getTask = Server.CreateObject("ADODB.Recordset")<BR>getTask. Open "tasks", dbCon, , , adCmdTable<BR>%&#062;<BR><BR>Error:<BR><BR>Detaile d Error Information<BR><BR>ASP Code: <BR>Error Number: -2147467259 <BR>Source Code: <BR>Category: Microsoft OLE DB Provider for ODBC Drivers <BR>Error Occurred in: /todo/todo.asp <BR>Line Number: 6 <BR>Column Number: -1 <BR>Description: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key &#039;Temporary (volatile) Jet DSN for process 0xc54 Thread 0xd20 DBC 0x1530d94 Jet&#039;. <BR><BR><BR>Thanks for ANY help you can give me!<BR>-Josh

  2. #2
    Join Date
    Dec 1969

    Default RE: DB Connection Help

    1. check the faqs (and www.aspfaq.com too) - if it&#039;s not covered in one of those I&#039;ll eat my hat<BR>2. use the OLEDB provider not the ODBC driver.<BR><BR><BR>j<BR>http://rtfm.atrax.co.uk/

Posting Permissions

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