|
 |
asp_web_howto thread: Re: ADO connection problem
Message #1 by "Li Wu" <liwu@g...> on Thu, 17 Jan 2002 09:02:12 -0500
|
|
Hi,
I have some asp pages using ADO to connect the Access and Oracle databases
on a window 2000 server. These pages worked fine until I downloaded and
installed the MDAC 2.7 from Microsoft web site.
The error message for openning Access database is "Microsoft OLE DB
Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified" and the error
message for Oracle database is "Microsoft OLE DB Provider for Oracle
(0x80004005)Oracle client and networking components were not found."
I can still open these database from a VB application using same ADO code
on this machine. So I thought that the IIS 5.0 maybe corrupted and I
reinstalled the IIS but the problem is still there.
Can anyone help me to solve this problem?
Thanks in advance for any suggestions!
Li
Message #2 by Oleg Kapeljushnik <c-oleg.kapeljushnik@w...> on Thu, 17 Jan 2002 09:14:27 -0500
|
|
Check you connection string before you make a connection, may be its empty.
If not and you using DSN for connection check that this DSN still exist and
reinstall didn't remove it.
Compare connection string from VB application and ASP.
Oleg
-----Original Message-----
From: Li Wu [mailto:liwu@g...]
Sent: January 17, 2002 9:02 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Re: ADO connection problem
Hi,
I have some asp pages using ADO to connect the Access and Oracle databases
on a window 2000 server. These pages worked fine until I downloaded and
installed the MDAC 2.7 from Microsoft web site.
The error message for openning Access database is "Microsoft OLE DB Provider
for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified" and the error message for
Oracle database is "Microsoft OLE DB Provider for Oracle (0x80004005)Oracle
client and networking components were not found."
I can still open these database from a VB application using same ADO code on
this machine. So I thought that the IIS 5.0 maybe corrupted and I
reinstalled the IIS but the problem is still there.
Can anyone help me to solve this problem?
Thanks in advance for any suggestions!
Li
$subst('Email.Unsub').
Message #3 by "Li Wu" <liwu@g...> on Thu, 17 Jan 2002 17:47:18
|
|
> Check you connection string before you make a connection, may be its
empty.
> If not and you using DSN for connection check that this DSN still exist
and
> reinstall didn't remove it.
>
> Compare connection string from VB application and ASP.
>
> Oleg
>
> -----Original Message-----
> From: Li Wu [mailto:liwu@g...]
> Sent: January 17, 2002 9:02 AM
> To: ASP Web HowTo
> Subject: [asp_web_howto] Re: ADO connection problem
>
>
> Hi,
>
> I have some asp pages using ADO to connect the Access and Oracle
databases
> on a window 2000 server. These pages worked fine until I downloaded and
> installed the MDAC 2.7 from Microsoft web site.
> The error message for openning Access database is "Microsoft OLE DB
Provider
> for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data
source
> name not found and no default driver specified" and the error message for
> Oracle database is "Microsoft OLE DB Provider for Oracle (0x80004005)
Oracle
> client and networking components were not found."
> I can still open these database from a VB application using same ADO
code on
> this machine. So I thought that the IIS 5.0 maybe corrupted and I
> reinstalled the IIS but the problem is still there.
> Can anyone help me to solve this problem?
> Thanks in advance for any suggestions!
> Li
>
>
>
>
>
> $subst('Email.Unsub').
>
Message #4 by "Li Wu" <liwu@g...> on Thu, 17 Jan 2002 17:51:52
|
|
Hi Oleg,
I use exactly same connection string for both VB and ASP.
Can I uninstall MDAC 2.7? Any idea?
Thanks,
Li
> Check you connection string before you make a connection, may be its
empty.
> If not and you using DSN for connection check that this DSN still exist
and
> reinstall didn't remove it.
>
> Compare connection string from VB application and ASP.
>
> Oleg
>
> -----Original Message-----
> From: Li Wu [mailto:liwu@g...]
> Sent: January 17, 2002 9:02 AM
> To: ASP Web HowTo
> Subject: [asp_web_howto] Re: ADO connection problem
>
>
> Hi,
>
> I have some asp pages using ADO to connect the Access and Oracle
databases
> on a window 2000 server. These pages worked fine until I downloaded and
> installed the MDAC 2.7 from Microsoft web site.
> The error message for openning Access database is "Microsoft OLE DB
Provider
> for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data
source
> name not found and no default driver specified" and the error message for
> Oracle database is "Microsoft OLE DB Provider for Oracle (0x80004005)
Oracle
> client and networking components were not found."
> I can still open these database from a VB application using same ADO
code on
> this machine. So I thought that the IIS 5.0 maybe corrupted and I
> reinstalled the IIS but the problem is still there.
> Can anyone help me to solve this problem?
> Thanks in advance for any suggestions!
> Li
>
>
>
>
>
> $subst('Email.Unsub').
>
Message #5 by Oleg Kapeljushnik <c-oleg.kapeljushnik@w...> on Thu, 17 Jan 2002 13:18:24 -0500
|
|
I didn't install MDAC2.7 but if it have uninstallation option try uninstall
it
and see what happens.
If not just try to write some simple ASP page that using the same
connection and/or other connection and see results.
Try to print connection string before you make a connection
cause may be its changed for some reason and it makes connection with wrong
connection string
Oleg
-----Original Message-----
From: Li Wu [mailto:liwu@g...]
Sent: January 17, 2002 5:52 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Re: ADO connection problem
Hi Oleg,
I use exactly same connection string for both VB and ASP.
Can I uninstall MDAC 2.7? Any idea?
Thanks,
Li
> Check you connection string before you make a connection, may be its
empty.
> If not and you using DSN for connection check that this DSN still exist
and
> reinstall didn't remove it.
>
> Compare connection string from VB application and ASP.
>
> Oleg
>
> -----Original Message-----
> From: Li Wu [mailto:liwu@g...]
> Sent: January 17, 2002 9:02 AM
> To: ASP Web HowTo
> Subject: [asp_web_howto] Re: ADO connection problem
>
>
> Hi,
>
> I have some asp pages using ADO to connect the Access and Oracle
databases
> on a window 2000 server. These pages worked fine until I downloaded and
> installed the MDAC 2.7 from Microsoft web site.
> The error message for openning Access database is "Microsoft OLE DB
Provider
> for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data
source
> name not found and no default driver specified" and the error message for
> Oracle database is "Microsoft OLE DB Provider for Oracle (0x80004005)
Oracle
> client and networking components were not found."
> I can still open these database from a VB application using same ADO
code on
> this machine. So I thought that the IIS 5.0 maybe corrupted and I
> reinstalled the IIS but the problem is still there.
> Can anyone help me to solve this problem?
> Thanks in advance for any suggestions!
> Li
>
>
>
>
>
> $subst('Email.Unsub').
>
$subst('Email.Unsub').
|
|
|
View Cart
