|
| |
|
|
lu lu
Posts: 418
From: wpg, mb
Status: offline
 |
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
Posts: 9227
From: Biddeford, ME USA
Status: offline
|
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....
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
