|
 |
asp_web_howto thread: ODBC error '80004005', but not error I've seen before...
Message #1 by "Jenifer Mundstock" <jenifer@s...> on Mon, 8 Apr 2002 15:56:52 -0500
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_00C9_01C1DF16.0005CFE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi all,
I created a website for a client of mine in ASP with a Microsoft Access
97 database backend and it was working just fine until he went in and
botched a FrontPage publish to the server. I've seen many ODBC error
messages for the '80004005' error, but this one is new to me. I've
searched through p2p.wrox.com and have only found the more common
message of exclusive locks or whatnot, but not this error.
Here is the error message:
--------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot open database
'(unknown)'. It may not be a database that your application recognizes,
or the file may be corrupt.
/Login/Login.asp, line 38
-------
The line it occurs on is my connection object instantiation:
--------
set oConn =3D createobject("ADODB.Connection")
oConn.open Application("DSN_Cust")
--------
And my application variable is set to something like this:
--------
Application("DSN_Cust") =3D
"filedsn=3DE:\Webs\1234\db\CustomerDB.dsn;DBQ=3DE:\Webs\1234\db\Customer.
mdb"
--------
At first I thought maybe the hosting provider changed servers or
remapped drives or something to make the path invalid, but I checked the
path and it is still the same. I then thought that the database got
corrupted so I copied a good version of the database to the server to no
avail. I can't figure out what the heck happened to cause this all to
stop working. I copied new files up from my machine (files that worked
before) and I still get this error.
Anyone have any ideas? This is driving me nuts.
Jenifer
Message #2 by Oleg Kapeljushnik <c-oleg.kapeljushnik@w...> on Mon, 08 Apr 2002 17:09:57 -0400
|
|
This is a multi-part message in MIME format.
--Boundary_(ID_GLv4gX4uou4hfe4q0DT15g)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: 7bit
The only I can think of right now that ODBC Access driver version was
changed.
May be some configuration was changed and some component was installed who
replaced old driver.
Just an idea.
Oleg.
-----Original Message-----
From: Jenifer Mundstock [mailto:jenifer@s...]
Sent: April 08, 2002 4:57 PM
To: ASP Web HowTo
Subject: [asp_web_howto] ODBC error '80004005', but not error I've seen
before...
Hi all,
I created a website for a client of mine in ASP with a Microsoft Access 97
database backend and it was working just fine until he went in and botched a
FrontPage publish to the server. I've seen many ODBC error messages for the
'80004005' error, but this one is new to me. I've searched through
p2p.wrox.com and have only found the more common message of exclusive locks
or whatnot, but not this error.
Here is the error message:
--------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot open database
'(unknown)'. It may not be a database that your application recognizes, or
the file may be corrupt.
/Login/Login.asp, line 38
-------
The line it occurs on is my connection object instantiation:
--------
set oConn = createobject("ADODB.Connection")
oConn.open Application("DSN_Cust")
--------
And my application variable is set to something like this:
--------
Application("DSN_Cust")
"filedsn=E:\Webs\1234\db\CustomerDB.dsn;DBQ=E:\Webs\1234\db\Customer.mdb"
--------
At first I thought maybe the hosting provider changed servers or remapped
drives or something to make the path invalid, but I checked the path and it
is still the same. I then thought that the database got corrupted so I
copied a good version of the database to the server to no avail. I can't
figure out what the heck happened to cause this all to stop working. I
copied new files up from my machine (files that worked before) and I still
get this error.
Anyone have any ideas? This is driving me nuts.
Jenifer
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 ---
Message #3 by "Owen Mortensen" <ojm@a...> on Mon, 8 Apr 2002 14:07:03 -0700
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0041_01C1DF06.A8D5DB70
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Might be a "permissions" problem?
Owen
-----Original Message-----
From: Jenifer Mundstock [mailto:jenifer@s...]
Sent: Monday, April 08, 2002 1:57 PM
To: ASP Web HowTo
Subject: [asp_web_howto] ODBC error '80004005', but not error I've seen
before...
Hi all,
I created a website for a client of mine in ASP with a Microsoft Access
97 database backend and it was working just fine until he went in and
botched a FrontPage publish to the server. I've seen many ODBC error
messages for the '80004005' error, but this one is new to me. I've
searched through p2p.wrox.com and have only found the more common
message of exclusive locks or whatnot, but not this error.
Here is the error message:
--------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot open database
'(unknown)'. It may not be a database that your application recognizes,
or the file may be corrupt.
/Login/Login.asp, line 38
-------
The line it occurs on is my connection object instantiation:
--------
set oConn = createobject("ADODB.Connection")
oConn.open Application("DSN_Cust")
--------
And my application variable is set to something like this:
--------
Application("DSN_Cust")
"filedsn=E:\Webs\1234\db\CustomerDB.dsn;DBQ=E:\Webs\1234\db\Customer.mdb
"
--------
At first I thought maybe the hosting provider changed servers or
remapped drives or something to make the path invalid, but I checked the
path and it is still the same. I then thought that the database got
corrupted so I copied a good version of the database to the server to no
avail. I can't figure out what the heck happened to cause this all to
stop working. I copied new files up from my machine (files that worked
before) and I still get this error.
Anyone have any ideas? This is driving me nuts.
Jenifer
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 ---
Message #4 by Eric Hobbs <ehobbs@l...> on Mon, 8 Apr 2002 14:16:28 -0700
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1DF42.A57DB880
Content-Type: text/plain
This might help...
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q310678
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;q310678>
- Eric
-----Original Message-----
From: Jenifer Mundstock [mailto:jenifer@s...]
Sent: Monday, April 08, 2002 1:57 PM
To: ASP Web HowTo
Subject: [asp_web_howto] ODBC error '80004005', but not error I've seen
before...
Hi all,
I created a website for a client of mine in ASP with a Microsoft Access 97
database backend and it was working just fine until he went in and botched a
FrontPage publish to the server. I've seen many ODBC error messages for the
'80004005' error, but this one is new to me. I've searched through
p2p.wrox.com and have only found the more common message of exclusive locks
or whatnot, but not this error.
Here is the error message:
--------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'.
It may not be a database that your application recognizes, or the file may
be corrupt.
/Login/Login.asp, line 38
-------
The line it occurs on is my connection object instantiation:
--------
set oConn = createobject("ADODB.Connection")
oConn.open Application("DSN_Cust")
--------
And my application variable is set to something like this:
--------
Application("DSN_Cust")
"filedsn=E:\Webs\1234\db\CustomerDB.dsn;DBQ=E:\Webs\1234\db\Customer.mdb"
--------
At first I thought maybe the hosting provider changed servers or remapped
drives or something to make the path invalid, but I checked the path and it
is still the same. I then thought that the database got corrupted so I
copied a good version of the database to the server to no avail. I can't
figure out what the heck happened to cause this all to stop working. I
copied new files up from my machine (files that worked before) and I still
get this error.
Anyone have any ideas? This is driving me nuts.
Jenifer
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 ---
Message #5 by "Jenifer Mundstock" <jenifer@s...> on Mon, 8 Apr 2002 17:05:38 -0500
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0114_01C1DF1F.9B8FFE50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Eric, thanks for the link! It points to a possible web server
permissions or driver issue, but my hosting provider is stating that
it's something that I've done and then pointed me to the file
permissions for the directory. The directory has full blown access
(rwx) etc. so this isn't it. grrr.
I've replied and asked if they've made any changes or recent installs to
the server and I'm now waiting for their response.
Thanks everyone for your ideas so far,
Jenifer
----- Original Message -----
From: Eric Hobbs
To: ASP Web HowTo
Sent: Monday, April 08, 2002 4:16 PM
Subject: [asp_web_howto] RE: ODBC error '80004005', but not error I've
see n before...
This might help...
http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;q310678
- Eric
-----Original Message-----
From: Jenifer Mundstock [mailto:jenifer@s...]
Sent: Monday, April 08, 2002 1:57 PM
To: ASP Web HowTo
Subject: [asp_web_howto] ODBC error '80004005', but not error I've
seen before...
Hi all,
I created a website for a client of mine in ASP with a Microsoft
Access 97 database backend and it was working just fine until he went in
and botched a FrontPage publish to the server. I've seen many ODBC
error messages for the '80004005' error, but this one is new to me.
I've searched through p2p.wrox.com and have only found the more common
message of exclusive locks or whatnot, but not this error.
Here is the error message:
--------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot open database
'(unknown)'. It may not be a database that your application recognizes,
or the file may be corrupt.
/Login/Login.asp, line 38
-------
The line it occurs on is my connection object instantiation:
--------
set oConn =3D createobject("ADODB.Connection")
oConn.open Application("DSN_Cust")
--------
And my application variable is set to something like this:
--------
Application("DSN_Cust") =3D
"filedsn=3DE:\Webs\1234\db\CustomerDB.dsn;DBQ=3DE:\Webs\1234\db\Customer.
mdb"
--------
At first I thought maybe the hosting provider changed servers or
remapped drives or something to make the path invalid, but I checked the
path and it is still the same. I then thought that the database got
corrupted so I copied a good version of the database to the server to no
avail. I can't figure out what the heck happened to cause this all to
stop working. I copied new files up from my machine (files that worked
before) and I still get this error.
Anyone have any ideas? This is driving me nuts.
Jenifer
--- Improve your web design skills with these new books from
Glasshaus. Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e r-20 ---
--- Improve your web design skills with these new books from
Glasshaus. Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e r-20 ---
Message #6 by "Phillip Conrad" <phillip.conrad@f...> on Tue, 9 Apr 2002 16:01:26
|
|
I got a similar error using an Excel spreadsheet and pulling the data
using ADO from ASP. What I did to resolve was (on the excel file) click
Properties | Security | Add... and added 'ANONYMOUS LOGON' for Read and
Read & Execute. So, you may need to specify ANONYMOUS if you haven't
already.
Message #7 by "Jenifer Mundstock" <jenifer@s...> on Tue, 9 Apr 2002 13:47:58 -0500
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0052_01C1DFCD.28804830
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi all,
Thanks so much for all of your responses. If you remember, I sent an
email to the hosting provider asking if they made any changes or
installs on the server and they never responded. BUT, the problem seems
to have magically "fixed" itself overnight. heh
Although I hate not knowing what the problem was... at least my client
is happy again.
Thanks again,
Jenifer
----- Original Message -----
From: Jenifer Mundstock
To: ASP Web HowTo
Sent: Monday, April 08, 2002 5:05 PM
Subject: [asp_web_howto] RE: ODBC error '80004005', but not error I've
see n before...
Eric, thanks for the link! It points to a possible web server
permissions or driver issue, but my hosting provider is stating that
it's something that I've done and then pointed me to the file
permissions for the directory. The directory has full blown access
(rwx) etc. so this isn't it. grrr.
I've replied and asked if they've made any changes or recent installs
to the server and I'm now waiting for their response.
Thanks everyone for your ideas so far,
Jenifer
|
|
|
View Cart
