|
| |
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
View related threads:
(in this forum
| in all forums)
|
Logged in as: Guest
|
|
|
fashiru
Posts: 5
Joined: 3/3/2004
Status: offline
 |
Microsoft OLE DB Provider for ODBC Drivers error '80004... - 3/10/2004 13:39:55
I got the messsage below while trying to test a database query online. It works on server ofline, but when i upload it to an internet server with asp support i got this. Can u pls figure out why these occur. Thanks
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 0x1168 Thread 0xb00 DBC 0x15b5ffc Jet'.
/portal/checkdetails.asp, line 103
|
|
|
|
rdouglass
Posts: 9167
From: Biddeford, ME USA
Status: offline
|
RE: Microsoft OLE DB Provider for ODBC Drivers error '8... - 3/10/2004 14:31:49
What are you using for DB connection code? a DSN-less connection? There are a few ways of trying it. For instance:
myDSN ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("\fpdb\myDB.mdb")
myDSN = Application("myDatabase_Connectstring")
myDSN = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("\fpdb\myDB.mdb")
are three different ways to access the same DB (OLEDB, global.asa, and ODBC). Your server may not be configured to work with the one you're using. Which one are you using and let's see if a different one works.
Also I've seen this problem with Access 2000+ DB's on older servers.
Hope it helps....
< Message edited by rdouglass -- 3/10/2004 14:32:12 >
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
fashiru
Posts: 5
Joined: 3/3/2004
Status: offline
|
RE: Microsoft OLE DB Provider for ODBC Drivers error '8... - 3/10/2004 16:51:39
This is the dns i'm using
<%
mpath= level & "db.mdb"
dsn = "DBQ=" & Server.Mappath(mpath) & ";Driver={Microsoft Access Driver (*.mdb)}"
%>
< Message edited by fashiru -- 3/10/2004 17:05:08 >
| |
|
|
|
rdouglass
Posts: 9167
From: Biddeford, ME USA
Status: offline
|
RE: Microsoft OLE DB Provider for ODBC Drivers error '8... - 3/11/2004 8:02:46
What happens when you use this:
dsn ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath(mpath)
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
fashiru
Posts: 5
Joined: 3/3/2004
Status: offline
|
RE: Microsoft OLE DB Provider for ODBC Drivers error '8... - 3/11/2004 9:58:24
This is what i got after i used it.
Microsoft JET Database Engine error '80004005'
Could not find installable ISAM.
| |
|
|
|
fashiru
Posts: 5
Joined: 3/3/2004
Status: offline
|
RE: Microsoft OLE DB Provider for ODBC Drivers error '8... - 3/11/2004 11:21:08
It's working perfectly on my own IIS server will my codes. The one i upload to my web host server is the one not working.
Below are codes:
This is my database include file, it saved as db.asp and it's included on the pages that requires database connection.
<%
level=""
SCRIPT_NAME = LCase(Request.ServerVariables("SCRIPT_NAME"))
if Instr(SCRIPT_NAME, "Check")>0 then
level=""
else
level="check/"
end if
mpath= level & "db.mdb"
dsn = "DBQ=" & Server.Mappath(mpath) & ";Driver={Microsoft Access Driver (*.mdb)}; PWD=password"
%>
And is my Sql
<%Set conn=Server.CreateObject("ADODB.Connection")
conn.Open dsn
SQL="SELECT * FROM Trans WHERE id = '" & request("id") & "'"
Set RS = Server.CreateObject("ADODB.Recordset")
rs.open sql, conn
| |
|
|
|
segemeister
Posts: 4
Joined: 11/1/2004
Status: offline
|
RE: Microsoft OLE DB Provider for ODBC Drivers error '8... - 11/7/2004 13:40:51
quote:
What happens when you use this:
dsn ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath(mpath)
Hey just wanted you guys to know that I briefly suffered from the same error. rdouglass, this quoted line works POIFECTLY after I subbed the "mpath" for my database path (which I assume is what u intended).
Cheers!
mE
| |
|
 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 
k¥ 