|
 |
asp_databases thread: R: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Message #1 by "Giovanni Salucci" <g.salucci@n...> on Thu, 21 Mar 2002 17:57:25 +0100
|
|
maybe a permission setting...
be sure the internet guest have read/write permission
to the folder cointainaing the access db...
some provider need some extra code to autenticate
user with read/write permission...
-----Messaggio originale-----
Da: Matt Sherman [mailto:mrpeanut1@j...]
Inviato: giovedì 21 marzo 2002 16.51
A: ASP Databases
Oggetto: [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
Message #2 by "Matt Sherman" <mrpeanut1@j...> on Thu, 21 Mar 2002 17:09:41
|
|
Yeah, I've done that also. The folder this database is in is the same
folder other databases are in that have been working. To be sure I even
reset the permissions so there would only be read, and I changed it back
to read/write/execute. And actually after I reset the permissions to only
read I tried it again to see if it would do something different and it
didn't. Apparently it's not even trying to connect to the database. It
doesn't like something in the code. And that's where I'm confused,
because everything works on my development machine. It's when I upload to
the server that I start having problems.
> maybe a permission setting...
be sure the internet guest have read/write permission
to the folder cointainaing the access db...
some provider need some extra code to autenticate
user with read/write permission...
-----Messaggio originale-----
Da: Matt Sherman [mailto:mrpeanut1@j...]
Inviato: giovedì 21 marzo 2002 16.51
A: ASP Databases
Oggetto: [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
|
|
|
View Cart
