|
| |
|
|
dpav29
Posts: 78
From: Brambleton VA USA
Status: offline
 |
Unique Connection Error/Problem - 4/29/2002 14:59:07
I have read the various strings re: this problem but I believe mine is unique, hence the new string:
I'm getting the DR error "[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x3e0 Thread 0x15f0 DBC 0x21b53bc Jet'."
However, I only get it on the pages wherein I used the FP DRW. I have other pages written in "native ASP" that work fine, so it seems the connection is OK.
Here's the backgroud:
I have a Web template and database shell that I deploy on multiple subwebs. Each time I deploy it on a new sub, I import all of the pages and upload the database to the new folder on my web server. After some slight modifications, it works fine. I have done this several times without problems until now.
The others still work fine, so I don't believe it is a problem with the server.
Any thoughts?
|
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Unique Connection Error/Problem - 4/29/2002 16:32:27
Are your other asp pages using ODBC or OLEDB for connection?
Mostly, asp coders use OLEDB over ODBC, so your asp pages may not have a problem.
As DRW uses ODBC by default, it may show on those pages.
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
|
|
dpav29
Posts: 78
From: Brambleton VA USA
Status: offline
|
RE: Unique Connection Error/Problem - 4/29/2002 16:47:49
Well I think this is what you are asking (the ASP pages were done by someone else, so this is new to me):
set con=server.CreateObject("ADODB.Connection")
set rs1=server.CreateObject("ADODB.Recordset")
con.CursorLocation = 3 'adUseClient
con.Open Application("cstr")
rs1.ActiveConnection=con
And here is what is in the global.asa file:
Sub Application_OnStart
Application("cstr")="PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=d:\websites\glenridgehealth.com\www\glenridgehealth.com\voha\fpdb\healthdata.mdb"
'==FrontPage Generated - startspan==
Dim FrontPage_UrlVars(1)
'--Project Data Connection
Application("Database2_ConnectionString") = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/healthdata.mdb"
As I mentioned, everything still works fine in my other webs with the identical pages.
Does that make sense?
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Unique Connection Error/Problem - 4/29/2002 19:13:27
As the other pages are working, you could try that same string to connect to the DRW pages (modify the global.asa file) :
'--Project Data Connection
Application("Database2_ConnectionString")="PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=d:\websites\glenridgehealth.com\www\glenridgehealth.com\voha\fpdb\healthdata.mdb"
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
 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 
