Microsoft OLE DB Provider for ODBC Drivers error '80004005' (Full Version)

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



Message

fashiru -> Microsoft OLE DB Provider for ODBC Drivers error '80004005' (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 -> RE: Microsoft OLE DB Provider for ODBC Drivers error '80004005' (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....



fashiru -> RE: Microsoft OLE DB Provider for ODBC Drivers error '80004005' (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)}"
%>



rdouglass -> RE: Microsoft OLE DB Provider for ODBC Drivers error '80004005' (3/11/2004 8:02:46)

What happens when you use this:

dsn ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath(mpath)



fashiru -> RE: Microsoft OLE DB Provider for ODBC Drivers error '80004005' (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.



rdouglass -> RE: Microsoft OLE DB Provider for ODBC Drivers error '80004005' (3/11/2004 10:34:50)

quote:

dsn = "DBQ=" & Server.Mappath(mpath) & ";Driver={Microsoft Access Driver (*.mdb)}"


Let's go back to using this one. Can you do a Response.write(sql) and post exactly what you're using for SQL?

Also, what happens when you do a simple query like "SELECT * FROM tableName"? Just trying to break it down to its' simplest form...[8|]



Spooky -> RE: Microsoft OLE DB Provider for ODBC Drivers error '80004005' (3/11/2004 11:13:08)

"The easiest fix for this, if you have access to the server, is to reinstall MDAC. If you are running on a web host, you will need to ask them to fix their data components. "

http://www.aspfaq.com/show.asp?id=2259



fashiru -> RE: Microsoft OLE DB Provider for ODBC Drivers error '80004005' (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 -> RE: Microsoft OLE DB Provider for ODBC Drivers error '80004005' (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



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625