using fp2000 with dsnless OLE DB error. (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

lu lu -> using fp2000 with dsnless OLE DB error. (11/1/2001 20:56:00)

What's causing this error, this is the first time i've been introduced to dsn-less...as i missing something:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xbe8 Thread 0x5f4 DBC 0xe8ff024 Jet'.

/part90.asp, line 53

line 53:
connDB.Open "DBQ=" & Server.MapPath("../fpdb/part1.mdb") & ";" & _

line 53 from this:

Set connDB = Server.CreateObject("ADODB.Connection")
connDB.Open "DBQ=" & Server.MapPath("../fpdb/part1.mdb") & ";" & _
"DRIVER=Microsoft Access Driver (*.mdb)"
Set RS = Server.CreateObject("ADODB.Recordset")

[This message has been edited by lu lu (edited 11-01-2001).]




rdouglass -> RE: using fp2000 with dsnless OLE DB error. (11/2/2001 15:02:00)

Just a guess, but is it an Access 2000 DB? If so, you'll probably need a different driver. Also, I think you have double quotes where they should be single. Try:

Set connDB = Server.CreateObject("ADODB.Connection")
connDB.Open "Data Source=" & Server.MapPath('../fpdb/part1.mdb') & ";" & _
"Provider=Microsoft.Jet.OLEDB.4.0"

Another guess would be your connDB.Open string might be backwards:

Set connDB = Server.CreateObject("ADODB.Connection")
connDB.Open "DRIVER=Microsoft Access Driver (*.mdb); DBQ=" & Server.MapPath('../fpdb/part1.mdb')

Just guessing and hope it helps....




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875