Welcome to HostingForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

ASP Appn: ADODB.Connection Is OK on XP#1, Fails on XP#2

 
   Web Hosting Problem Solving Community! (Home) -> IIS RSS
Next:  help creating a virtual root across a firewall  
Author Message
ashore

External


Since: Sep 04, 2003
Posts: 1



(Msg. 1) Posted: Thu Sep 04, 2003 8:20 pm
Post subject: ASP Appn: ADODB.Connection Is OK on XP#1, Fails on XP#2
Archived from groups: microsoft>public>inetserver>iis (more info?)

Hope you guys can suggest where to start looking. I've loaded subject app
on a new XP notebook, gotten IIS's dirs and ODBC defined OK - AFAIK.

The new XP is at SP#1 with 282010, the old XP isn't.

The problem is that I can't get past the first ADODB.Connection attempt - to
an ACCESS 2002 mdb. The complaint:
Provider=Microsoft.Jet.OLEDB.4.0; Data Source=
C:\Inetpub\Scripts\WFIEph\WFIEdb\WFIEdb.mdb; Mode=Share Deny None;User
Id=admin;PASSWORD=; :18
Error@27: -2147467259 (The "Error@ ... " is my script.)

The script with which I'm testing is a simple generic lister of an mdb's
contents, and works fine on PC#1. The file is RW, and I'm using no
password, for now. I'll guess that the pblm's root is some security default
that's new in XP SP#1, but I can't find it.

Will appreciate any help, guys. Thanks,

AS

 >> Stay informed about: ASP Appn: ADODB.Connection Is OK on XP#1, Fails on XP#2 
Back to top
Login to vote
user645

External


Since: Aug 23, 2003
Posts: 180



(Msg. 2) Posted: Fri Sep 05, 2003 11:18 am
Post subject: Re: ASP Appn: ADODB.Connection Is OK on XP#1, Fails on XP#2 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"Arnold Shore" <ashore.RemoveThis@saefern.org> wrote in message
news:umRQ1pycDHA.372@TK2MSFTNGP11.phx.gbl...
 > Hope you guys can suggest where to start looking. I've loaded subject app
 > on a new XP notebook, gotten IIS's dirs and ODBC defined OK - AFAIK.
 >
 > The new XP is at SP#1 with 282010, the old XP isn't.
 > The script with which I'm testing is a simple generic lister of an mdb's
 > contents, and works fine on PC#1. The file is RW, and I'm using no
 > password, for now. I'll guess that the pblm's root is some security
default
 > that's new in XP SP#1, but I can't find it.
 >
 > Will appreciate any help, guys. Thanks,
Be sure to allow IUSR_xx read/write access on that MDB. If users must logon
they also need to have access .For instance, allow 'authenticated users' to
have read/write access.

 > AS
 >
 ><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: ASP Appn: ADODB.Connection Is OK on XP#1, Fails on XP#2 
Back to top
Login to vote
kenremove

External


Since: Aug 23, 2003
Posts: 3041



(Msg. 3) Posted: Fri Sep 05, 2003 7:19 pm
Post subject: Re: ASP Appn: ADODB.Connection Is OK on XP#1, Fails on XP#2 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

That error number is 80004005, which is usually Unspecified Error... Sad
However, you might want to remove your error handling code so that you can
see if there is any error text (sometimes there is useful text, unlike
"Unspecified Error")

Cheers
Ken


"Arnold Shore" <ashore.RemoveThis@saefern.org> wrote in message
news:umRQ1pycDHA.372@TK2MSFTNGP11.phx.gbl...
: Hope you guys can suggest where to start looking. I've loaded subject app
: on a new XP notebook, gotten IIS's dirs and ODBC defined OK - AFAIK.
:
: The new XP is at SP#1 with 282010, the old XP isn't.
:
: The problem is that I can't get past the first ADODB.Connection attempt -
to
: an ACCESS 2002 mdb. The complaint:
: Provider=Microsoft.Jet.OLEDB.4.0; Data Source=
: C:\Inetpub\Scripts\WFIEph\WFIEdb\WFIEdb.mdb; Mode=Share Deny None;User
: Id=admin;PASSWORD=; :18
: Error@27: -2147467259 (The "Error@ ... " is my script.)
:
: The script with which I'm testing is a simple generic lister of an mdb's
: contents, and works fine on PC#1. The file is RW, and I'm using no
: password, for now. I'll guess that the pblm's root is some security
default
: that's new in XP SP#1, but I can't find it.
:
: Will appreciate any help, guys. Thanks,
:
: AS
:
:
 >> Stay informed about: ASP Appn: ADODB.Connection Is OK on XP#1, Fails on XP#2 
Back to top
Login to vote
jameshowonline

External


Since: Aug 26, 2003
Posts: 71



(Msg. 4) Posted: Sun Sep 07, 2003 11:55 pm
Post subject: RE: ASP Appn: ADODB.Connection Is OK on XP#1, Fails on XP#2 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You might want to post in the microsoft.public.inetserver.asp,
microsoft.public.vsstudio or microsoft.public.ado.


Thanks.

James Howard -- IIS Support Professional

Be secure: Apply the latest Security Patches for IIS:
http://www.microsoft.com/security


Search our online Knowledge Base
http://support.microsoft.com/support/

This posting is provided “AS IS” with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved
 >> Stay informed about: ASP Appn: ADODB.Connection Is OK on XP#1, Fails on XP#2 
Back to top
Login to vote
Display posts from previous:   
   Web Hosting Problem Solving Community! (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]