|
 |
asp_database_setup thread: Connection Unable to open registry key
Message #1 by "Ben Smith" <ben@b...> on Sat, 17 Feb 2001 10:36:53 -0000
|
|
Hi
I'm using Windows 2000 Professional, with IIS and Data Access Components 2.6
installed.
When using the following connection string:
strConn = "Driver={Microsoft Access Driver
(*.mdb)};DBQ=c:\files\database.mdb"
I get the following error message:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x5f0 Thread 0x714
DBC 0x15d4074 Jet'.
/fairlawn/quote/quote.asp, line 3
What have I done wrong? - if I change the connection to a system DSN,
everything is fine.
Any feedback greatly appreciated,
Ben Smith
E-Mail: ben@b...
Message #2 by Imar Spaanjaars <Imar@S...> on Sat, 17 Feb 2001 13:58:21 +0100
|
|
You are using a bit outdated connectionstring. Try the following instead.
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\files\database.mdb;" & _
"User Id=admin;" & _
"Password=;"
And see
http://www.able-consulting.com/ado_conn.htm#OLEDBProviderForMicrosoftJet
for more connectionstring examples.
Hope this helps,
Imar
At 11:38 AM 2/17/2001 -0800, you wrote:
>Hi
>
>I'm using Windows 2000 Professional, with IIS and Data Access Components 2.6
>installed.
>
>When using the following connection string:
>
>strConn = "Driver={Microsoft Access Driver
>(*.mdb)};DBQ=c:\files\database.mdb"
>
>I get the following error message:
>
>Error Type:
>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
>registry key 'Temporary (volatile) Jet DSN for process 0x5f0 Thread 0x714
>DBC 0x15d4074 Jet'.
>/fairlawn/quote/quote.asp, line 3
>
>
>What have I done wrong? - if I change the connection to a system DSN,
>everything is fine.
>
>Any feedback greatly appreciated,
>
>Ben Smith
>
>E-Mail: ben@b...
Message #3 by "Ken Schaefer" <ken@a...> on Mon, 19 Feb 2001 17:08:38 +1100
|
|
You need either:
a) delete and recreate your DSN
b) (better) switch to OLEDB. You error is covered here:
http://www.adOpenStatic.com/faq/whyOLEDB.asp
Cheers
Ken
----- Original Message -----
From: "Ben Smith" <ben@b...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Sunday, February 18, 2001 6:38 AM
Subject: [asp_database_setup] Connection Unable to open registry key
> Hi
>
> I'm using Windows 2000 Professional, with IIS and Data Access Components
2.6
> installed.
>
> When using the following connection string:
>
> strConn = "Driver={Microsoft Access Driver
> (*.mdb)};DBQ=c:\files\database.mdb"
>
> I get the following error message:
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
> registry key 'Temporary (volatile) Jet DSN for process 0x5f0 Thread 0x714
> DBC 0x15d4074 Jet'.
> /fairlawn/quote/quote.asp, line 3
|
|
|
View Cart
