Windows 2000/Oracle 9i/MDAC 2.6

[Bill]

I'm having trouble connecting to this machine using the
following:

Set OracleConn = Server.CreateObject("adodb.connection")
OracleConn.Open "Provider=msdaora;Data Source=db;User
ID=user;Password=pass"

The machine:
Windows 2000/MDAC 2.6/Oracle 9i client

Error Message:
Microsoft OLE DB Provider for Oracle error '80004005'

Oracle client and networking components were not found.
These components are supplied by Oracle Corporation and
are part of the Oracle Version 7.3.3 or later client
software installation. Provider is unable to function
until these components are installed.


Now the same connection worked flawlessly on a Windows
NT4.0/Oracle 8i client machine. When I tried to move the
application to a production machine, I started to get this
error. Please help, it goes live in 3 days. ANy and all
help would be appreciated.

Bill

[John Blessing]

"Bill" <anonymous@discussions.microsoft.com> wrote in message
news:00a101c423f4$26397a70$a101280a@phx.gbl...

> I'm having trouble connecting to this machine using the
> following:
>
> Set OracleConn = Server.CreateObject("adodb.connection")
> OracleConn.Open "Provider=msdaora;Data Source=db;User
> ID=user;Password=pass"
>
> The machine:
> Windows 2000/MDAC 2.6/Oracle 9i client
>
> Error Message:
> Microsoft OLE DB Provider for Oracle error '80004005'
>
> Oracle client and networking components were not found.
> These components are supplied by Oracle Corporation and
> are part of the Oracle Version 7.3.3 or later client
> software installation. Provider is unable to function
> until these components are installed.
>
>
> Now the same connection worked flawlessly on a Windows
> NT4.0/Oracle 8i client machine. When I tried to move the
> application to a production machine, I started to get this
> error. Please help, it goes live in 3 days. ANy and all
> help would be appreciated.
>
> Bill

IIRC the MS OLEDB provider does not support Oracle 9, you have to use
Oracle's OLEDB driver.

--
John Blessing

[url]http://www.LbeHelpdesk.com[/url] - Help Desk software priced to suit all
businesses
[url]http://www.free-helpdesk.com[/url] - Completely free help desk software !
[url]http://www.lbetoolbox.com[/url] - Remove Duplicates from MS Outlook

[Mark Schupp]

You could also try installing the Oracle Net8 client on the web-server if
you must use the Microsoft drivers.

--
Mark Schupp
Head of Development
Integrity eLearning
[url]www.ielearning.com[/url]


"John Blessing" <jb@**REMOVE**THIS**LbeHelpdesk.com> wrote in message
news:XBbgc.84$D84.31@newsfe1-win...

> "Bill" <anonymous@discussions.microsoft.com> wrote in message
> news:00a101c423f4$26397a70$a101280a@phx.gbl...

> > I'm having trouble connecting to this machine using the
> > following:
> >
> > Set OracleConn = Server.CreateObject("adodb.connection")
> > OracleConn.Open "Provider=msdaora;Data Source=db;User
> > ID=user;Password=pass"
> >
> > The machine:
> > Windows 2000/MDAC 2.6/Oracle 9i client
> >
> > Error Message:
> > Microsoft OLE DB Provider for Oracle error '80004005'
> >
> > Oracle client and networking components were not found.
> > These components are supplied by Oracle Corporation and
> > are part of the Oracle Version 7.3.3 or later client
> > software installation. Provider is unable to function
> > until these components are installed.
> >
> >
> > Now the same connection worked flawlessly on a Windows
> > NT4.0/Oracle 8i client machine. When I tried to move the
> > application to a production machine, I started to get this
> > error. Please help, it goes live in 3 days. ANy and all
> > help would be appreciated.
> >
> > Bill

>
> IIRC the MS OLEDB provider does not support Oracle 9, you have to use
> Oracle's OLEDB driver.
>
> --
> John Blessing
>
> [url]http://www.LbeHelpdesk.com[/url] - Help Desk software priced to suit all
> businesses
> [url]http://www.free-helpdesk.com[/url] - Completely free help desk software !
> [url]http://www.lbetoolbox.com[/url] - Remove Duplicates from MS Outlook
>
>