|
 |
asp_databases thread: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Message #1 by "Matt Sherman" <mrpeanut1@j...> on Thu, 21 Mar 2002 15:58:13
|
|
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 0xabc Thread 0xba4
DBC 0x211a70f4 Jet'.
This is the error I'm getting.
I'm using a DSN-less connection.
The code looks like this:
set objConn=server.createobject("adodb.connection")
objConn.Open "Driver={Microsoft Access Driver (*.mdb)};
DBQ=D:\64.224.27.253\MTREngine\wmtr\WTRX.MDB"
strSQL="select * from PASSWORD where NAME='"
strSQL=strSQL & UserName & "'"
set objRS=objConn.execute(strSQL)
It's funny because it works on my computer with PWS, but when I upload it
to the web server I start getting this error. What's up?
Any help will be appreciated.
Thanks.
Message #2 by "Craig Flannigan" <ckf@k...> on Thu, 21 Mar 2002 15:56:44 -0000
|
|
When I used to get those errors, it was because of the path that I was
specifying to the database was wrong.
Is... "D:\64.224.27.253\MTREngine\wmtr\WTRX.MDB" Correct?
-----Original Message-----
From: Matt Sherman [mailto:mrpeanut1@j...]
Sent: 21 March 2002 15:58
To: ASP Databases
Subject: [asp_databases] Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
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 0xabc Thread 0xba4
DBC 0x211a70f4 Jet'.
This is the error I'm getting.
I'm using a DSN-less connection.
The code looks like this:
set objConn=server.createobject("adodb.connection")
objConn.Open "Driver={Microsoft Access Driver (*.mdb)};
DBQ=D:\64.224.27.253\MTREngine\wmtr\WTRX.MDB"
strSQL="select * from PASSWORD where NAME='"
strSQL=strSQL & UserName & "'"
set objRS=objConn.execute(strSQL)
It's funny because it works on my computer with PWS, but when I upload it
to the web server I start getting this error. What's up?
Any help will be appreciated.
Thanks.
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
Message #3 by "Matt Sherman" <mrpeanut1@j...> on Thu, 21 Mar 2002 16:29:01
|
|
Yes, I did think about that. I've checked it a couple times just to make
sure I wasn't missing something. I still might be, so I'll check it
again, but I'm almost positive that's not what the problem is.
> When I used to get those errors, it was because of the path that I was
specifying to the database was wrong.
Is... "D:\64.224.27.253\MTREngine\wmtr\WTRX.MDB" Correct?
-----Original Message-----
From: Matt Sherman [mailto:mrpeanut1@j...]
Sent: 21 March 2002 15:58
To: ASP Databases
Subject: [asp_databases] Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
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 0xabc Thread 0xba4
DBC 0x211a70f4 Jet'.
This is the error I'm getting.
I'm using a DSN-less connection.
The code looks like this:
set objConn=server.createobject("adodb.connection")
objConn.Open "Driver={Microsoft Access Driver (*.mdb)};
DBQ=D:\64.224.27.253\MTREngine\wmtr\WTRX.MDB"
strSQL="select * from PASSWORD where NAME='"
strSQL=strSQL & UserName & "'"
set objRS=objConn.execute(strSQL)
It's funny because it works on my computer with PWS, but when I upload it
to the web server I start getting this error. What's up?
Any help will be appreciated.
Thanks.
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
Message #4 by "Craig Flannigan" <ckf@k...> on Thu, 21 Mar 2002 16:27:32 -0000
|
|
Daft Question, but is that an IP Address or Folder that you're specifying...
---> "D:\64.224.27.253"
-----Original Message-----
From: Matt Sherman [mailto:mrpeanut1@j...]
Sent: 21 March 2002 16:29
To: ASP Databases
Subject: [asp_databases] RE: Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
Yes, I did think about that. I've checked it a couple times just to make
sure I wasn't missing something. I still might be, so I'll check it
again, but I'm almost positive that's not what the problem is.
> When I used to get those errors, it was because of the path that I was
specifying to the database was wrong.
Is... "D:\64.224.27.253\MTREngine\wmtr\WTRX.MDB" Correct?
-----Original Message-----
From: Matt Sherman [mailto:mrpeanut1@j...]
Sent: 21 March 2002 15:58
To: ASP Databases
Subject: [asp_databases] Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
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 0xabc Thread 0xba4
DBC 0x211a70f4 Jet'.
This is the error I'm getting.
I'm using a DSN-less connection.
The code looks like this:
set objConn=server.createobject("adodb.connection")
objConn.Open "Driver={Microsoft Access Driver (*.mdb)};
DBQ=D:\64.224.27.253\MTREngine\wmtr\WTRX.MDB"
strSQL="select * from PASSWORD where NAME='"
strSQL=strSQL & UserName & "'"
set objRS=objConn.execute(strSQL)
It's funny because it works on my computer with PWS, but when I upload it
to the web server I start getting this error. What's up?
Any help will be appreciated.
Thanks.
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
Message #5 by "Matt Sherman" <mrpeanut1@j...> on Thu, 21 Mar 2002 16:50:41
|
|
It's both.
It's actually the IP Address of the site, but it is also the folder on the
hard drive that the site is in. The site is hosted on a server by
Interland, apparently that's a convention they use to keep accounts
seperate.
> Daft Question, but is that an IP Address or Folder that you're
specifying...
---> "D:\64.224.27.253"
-----Original Message-----
From: Matt Sherman [mailto:mrpeanut1@j...]
Sent: 21 March 2002 16:29
To: ASP Databases
Subject: [asp_databases] RE: Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
Yes, I did think about that. I've checked it a couple times just to make
sure I wasn't missing something. I still might be, so I'll check it
again, but I'm almost positive that's not what the problem is.
> When I used to get those errors, it was because of the path that I was
specifying to the database was wrong.
Is... "D:\64.224.27.253\MTREngine\wmtr\WTRX.MDB" Correct?
-----Original Message-----
From: Matt Sherman [mailto:mrpeanut1@j...]
Sent: 21 March 2002 15:58
To: ASP Databases
Subject: [asp_databases] Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
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 0xabc Thread 0xba4
DBC 0x211a70f4 Jet'.
This is the error I'm getting.
I'm using a DSN-less connection.
The code looks like this:
set objConn=server.createobject("adodb.connection")
objConn.Open "Driver={Microsoft Access Driver (*.mdb)};
DBQ=D:\64.224.27.253\MTREngine\wmtr\WTRX.MDB"
strSQL="select * from PASSWORD where NAME='"
strSQL=strSQL & UserName & "'"
set objRS=objConn.execute(strSQL)
It's funny because it works on my computer with PWS, but when I upload it
to the web server I start getting this error. What's up?
Any help will be appreciated.
Thanks.
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
Message #6 by "Ken Schaefer" <ken@a...> on Fri, 22 Mar 2002 09:47:13 +1100
|
|
Use the OLEDB Provider, not the ODBC Driver:
www.adopenstatic.com/faq/whyOLEDB.asp
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Matt Sherman" <mrpeanut1@j...>
Subject: [asp_databases] Microsoft OLE DB Provider for ODBC Drivers error
'80004005'
: 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 0xabc Thread 0xba4
: DBC 0x211a70f4 Jet'.
:
: This is the error I'm getting.
: I'm using a DSN-less connection.
:
: The code looks like this:
:
: set objConn=server.createobject("adodb.connection")
: objConn.Open "Driver={Microsoft Access Driver (*.mdb)};
: DBQ=D:\64.224.27.253\MTREngine\wmtr\WTRX.MDB"
:
: strSQL="select * from PASSWORD where NAME='"
: strSQL=strSQL & UserName & "'"
: set objRS=objConn.execute(strSQL)
:
: It's funny because it works on my computer with PWS, but when I upload it
: to the web server I start getting this error. What's up?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #7 by "Craig Flannigan" <ckf@k...> on Fri, 22 Mar 2002 08:18:33 -0000
|
|
On the page that is causing an error, place this at the top of the page.
<% Response.write Server.MapPath(".") %>
Run it again, then post the result...
-----Original Message-----
From: Matt Sherman [mailto:mrpeanut1@j...]
Sent: 21 March 2002 16:51
To: ASP Databases
Subject: [asp_databases] RE: Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
It's both.
It's actually the IP Address of the site, but it is also the folder on the
hard drive that the site is in. The site is hosted on a server by
Interland, apparently that's a convention they use to keep accounts
seperate.
> Daft Question, but is that an IP Address or Folder that you're
specifying...
---> "D:\64.224.27.253"
-----Original Message-----
From: Matt Sherman [mailto:mrpeanut1@j...]
Sent: 21 March 2002 16:29
To: ASP Databases
Subject: [asp_databases] RE: Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
Yes, I did think about that. I've checked it a couple times just to make
sure I wasn't missing something. I still might be, so I'll check it
again, but I'm almost positive that's not what the problem is.
> When I used to get those errors, it was because of the path that I was
specifying to the database was wrong.
Is... "D:\64.224.27.253\MTREngine\wmtr\WTRX.MDB" Correct?
-----Original Message-----
From: Matt Sherman [mailto:mrpeanut1@j...]
Sent: 21 March 2002 15:58
To: ASP Databases
Subject: [asp_databases] Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
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 0xabc Thread 0xba4
DBC 0x211a70f4 Jet'.
This is the error I'm getting.
I'm using a DSN-less connection.
The code looks like this:
set objConn=server.createobject("adodb.connection")
objConn.Open "Driver={Microsoft Access Driver (*.mdb)};
DBQ=D:\64.224.27.253\MTREngine\wmtr\WTRX.MDB"
strSQL="select * from PASSWORD where NAME='"
strSQL=strSQL & UserName & "'"
set objRS=objConn.execute(strSQL)
It's funny because it works on my computer with PWS, but when I upload it
to the web server I start getting this error. What's up?
Any help will be appreciated.
Thanks.
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
Message #8 by "Craig Flannigan" <ckf@k...> on Fri, 22 Mar 2002 08:23:34 -0000
|
|
Try this...
Dim objConn, objRst, strSQL
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRst = Server.CreateObject("ADODB.Recordset")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.Mappath("YourDBfile.mdb")
This will give you a more obvious error message apart from being a better
provider. The Server.MapPath part needs to have your full path from the ROOT
upto your DB.
-----Original Message-----
From: Matt Sherman [mailto:mrpeanut1@j...]
Sent: 21 March 2002 16:51
To: ASP Databases
Subject: [asp_databases] RE: Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
It's both.
It's actually the IP Address of the site, but it is also the folder on the
hard drive that the site is in. The site is hosted on a server by
Interland, apparently that's a convention they use to keep accounts
seperate.
> Daft Question, but is that an IP Address or Folder that you're
specifying...
---> "D:\64.224.27.253"
-----Original Message-----
From: Matt Sherman [mailto:mrpeanut1@j...]
Sent: 21 March 2002 16:29
To: ASP Databases
Subject: [asp_databases] RE: Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
Yes, I did think about that. I've checked it a couple times just to make
sure I wasn't missing something. I still might be, so I'll check it
again, but I'm almost positive that's not what the problem is.
> When I used to get those errors, it was because of the path that I was
specifying to the database was wrong.
Is... "D:\64.224.27.253\MTREngine\wmtr\WTRX.MDB" Correct?
-----Original Message-----
From: Matt Sherman [mailto:mrpeanut1@j...]
Sent: 21 March 2002 15:58
To: ASP Databases
Subject: [asp_databases] Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
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 0xabc Thread 0xba4
DBC 0x211a70f4 Jet'.
This is the error I'm getting.
I'm using a DSN-less connection.
The code looks like this:
set objConn=server.createobject("adodb.connection")
objConn.Open "Driver={Microsoft Access Driver (*.mdb)};
DBQ=D:\64.224.27.253\MTREngine\wmtr\WTRX.MDB"
strSQL="select * from PASSWORD where NAME='"
strSQL=strSQL & UserName & "'"
set objRS=objConn.execute(strSQL)
It's funny because it works on my computer with PWS, but when I upload it
to the web server I start getting this error. What's up?
Any help will be appreciated.
Thanks.
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
Message #9 by "Matt Sherman" <mrpeanut1@j...> on Fri, 22 Mar 2002 15:39:14
|
|
Hey,
Thanks for all the help. Using OLE worked. I don't know why I didn't try
that. I've been using it for my dBase databases, just not Access.
Anyway, thanks for the help.
> Try this...
Dim objConn, objRst, strSQL
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRst = Server.CreateObject("ADODB.Recordset")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.Mappath("YourDBfile.mdb")
This will give you a more obvious error message apart from being a better
provider. The Server.MapPath part needs to have your full path from the
ROOT
upto your DB.
-----Original Message-----
From: Matt Sherman [mailto:mrpeanut1@j...]
Sent: 21 March 2002 16:51
To: ASP Databases
Subject: [asp_databases] RE: Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
It's both.
It's actually the IP Address of the site, but it is also the folder on the
hard drive that the site is in. The site is hosted on a server by
Interland, apparently that's a convention they use to keep accounts
seperate.
> Daft Question, but is that an IP Address or Folder that you're
specifying...
---> "D:\64.224.27.253"
-----Original Message-----
From: Matt Sherman [mailto:mrpeanut1@j...]
Sent: 21 March 2002 16:29
To: ASP Databases
Subject: [asp_databases] RE: Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
Yes, I did think about that. I've checked it a couple times just to make
sure I wasn't missing something. I still might be, so I'll check it
again, but I'm almost positive that's not what the problem is.
> When I used to get those errors, it was because of the path that I was
specifying to the database was wrong.
Is... "D:\64.224.27.253\MTREngine\wmtr\WTRX.MDB" Correct?
-----Original Message-----
From: Matt Sherman [mailto:mrpeanut1@j...]
Sent: 21 March 2002 15:58
To: ASP Databases
Subject: [asp_databases] Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
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 0xabc Thread 0xba4
DBC 0x211a70f4 Jet'.
This is the error I'm getting.
I'm using a DSN-less connection.
The code looks like this:
set objConn=server.createobject("adodb.connection")
objConn.Open "Driver={Microsoft Access Driver (*.mdb)};
DBQ=D:\64.224.27.253\MTREngine\wmtr\WTRX.MDB"
strSQL="select * from PASSWORD where NAME='"
strSQL=strSQL & UserName & "'"
set objRS=objConn.execute(strSQL)
It's funny because it works on my computer with PWS, but when I upload it
to the web server I start getting this error. What's up?
Any help will be appreciated.
Thanks.
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
|
|
|
View Cart
