p2p.wrox.com: Archives - asp

asp_databases thread: ASP Oracle Database Connection Problem

Message #1 by "David E" <registerukh@h...> on Sat, 14 Oct 2000 23:18:29 EDT

I am getting some error while connecting to Oracle database using IP address 

of the database server. Also I am using the OLE-DB.



The following things I am using:



1. windows NT 4.1 and IIS

2. Oracle 8.(something) on separate server.

3. code is Provider=MSDAORA.1;Password=something;User ID=something;Data 

Source=999.999.9.99;

4. I am getting the following error:



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.



/compass/dbconn.asp, line 5





5. I have found something about this error on msdn site but I could not make 

out what it is saying. Do, I need to install something on my NT server or 

something.



So, my request to you guys is to just tell me what I need to do to get this 

darn thing working.



TIA

Message #2 by "Dallas Martin" <dmartin@z...> on Sun, 15 Oct 2000 18:46:31 -0400

you need SqlNet on the Webserver as a client to the Oracle Listener on the

Oracel DB Server.





----- Original Message -----

From: "David E" <registerukh@h...>

To: "ASP Databases" <asp_databases@p...>

Sent: Saturday, October 14, 2000 11:18 PM

Subject: [asp_databases] ASP Oracle Database Connection Problem





> I am getting some error while connecting to Oracle database using IP

address

> of the database server. Also I am using the OLE-DB.

>

> The following things I am using:

>

> 1. windows NT 4.1 and IIS

> 2. Oracle 8.(something) on separate server.

> 3. code is Provider=MSDAORA.1;Password=something;User ID=something;Data

> Source=999.999.9.99;

> 4. I am getting the following error:

>

> 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.

>

> /compass/dbconn.asp, line 5

>

>

> 5. I have found something about this error on msdn site but I could not

make

> out what it is saying. Do, I need to install something on my NT server or

> something.

>

> So, my request to you guys is to just tell me what I need to do to get

this

> darn thing working.

>

> TIA

>

>

>

> ---

> FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

> INSIGHTS IN YOUR INBOX!

> Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips,

tools, and

> developments from the experts.  Sign up for one or more of EarthWeb?s

> FREE IT newsletters at http://www.earthweb.com today!

> ---

Message #3 by "David E" <registerukh@h...> on Mon, 16 Oct 2000 22:25:13 EDT

Thanks Martin for your help. I just did what you had suggested and it worked 

wonderfully.



Thanks again.





>From: "Dallas Martin" <dmartin@z...>

>Reply-To: "ASP Databases" <asp_databases@p...>

>To: "ASP Databases" <asp_databases@p...>

>Subject: [asp_databases] Re: ASP Oracle Database Connection Problem

>Date: Sun, 15 Oct 2000 18:46:31 -0400

>

>you need SqlNet on the Webserver as a client to the Oracle Listener on the

>Oracel DB Server.

>

>

>----- Original Message -----

>From: "David E" <registerukh@h...>

>To: "ASP Databases" <asp_databases@p...>

>Sent: Saturday, October 14, 2000 11:18 PM

>Subject: [asp_databases] ASP Oracle Database Connection Problem

>

>

> > I am getting some error while connecting to Oracle database using IP

>address

> > of the database server. Also I am using the OLE-DB.

> >

> > The following things I am using:

> >

> > 1. windows NT 4.1 and IIS

> > 2. Oracle 8.(something) on separate server.

> > 3. code is Provider=MSDAORA.1;Password=something;User ID=something;Data

> > Source=999.999.9.99;

> > 4. I am getting the following error:

> >

> > 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.

> >

> > /compass/dbconn.asp, line 5

> >

> >

> > 5. I have found something about this error on msdn site but I could not

>make

> > out what it is saying. Do, I need to install something on my NT server 

>or

> > something.

> >

> > So, my request to you guys is to just tell me what I need to do to get

>this

> > darn thing working.

> >

> > TIA

> >

>

Message #4 by "David E" <registerukh@h...> on Mon, 16 Oct 2000 22:25:15 EDT

Thanks Martin for your help. I just did what you had suggested and it worked 

wonderfully.



Thanks again.





>From: "Dallas Martin" <dmartin@z...>

>Reply-To: "ASP Databases" <asp_databases@p...>

>To: "ASP Databases" <asp_databases@p...>

>Subject: [asp_databases] Re: ASP Oracle Database Connection Problem

>Date: Sun, 15 Oct 2000 18:46:31 -0400

>

>you need SqlNet on the Webserver as a client to the Oracle Listener on the

>Oracel DB Server.

>

>

>----- Original Message -----

>From: "David E" <registerukh@h...>

>To: "ASP Databases" <asp_databases@p...>

>Sent: Saturday, October 14, 2000 11:18 PM

>Subject: [asp_databases] ASP Oracle Database Connection Problem

>

>

> > I am getting some error while connecting to Oracle database using IP

>address

> > of the database server. Also I am using the OLE-DB.

> >

> > The following things I am using:

> >

> > 1. windows NT 4.1 and IIS

> > 2. Oracle 8.(something) on separate server.

> > 3. code is Provider=MSDAORA.1;Password=something;User ID=something;Data

> > Source=999.999.9.99;

> > 4. I am getting the following error:

> >

> > 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.

> >

> > /compass/dbconn.asp, line 5

> >

> >

> > 5. I have found something about this error on msdn site but I could not

>make

> > out what it is saying. Do, I need to install something on my NT server 

>or

> > something.

> >

> > So, my request to you guys is to just tell me what I need to do to get

>this

> > darn thing working.

> >

> > TIA

> >

> >

> >

> > ---

> > FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

> > INSIGHTS IN YOUR INBOX!

> > Get the latest and best C++, Visual C++, Java, Visual Basic, and XML 

>tips,

>tools, and

> > developments from the experts.  Sign up for one or more of EarthWeb?s

> > FREE IT newsletters at http://www.earthweb.com today!

> > ---

>

>

>---

>NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?

>Visit EarthWeb for the latest in IT Management, Software Development,

>Web Development, Networking & Communications, and Hardware & Systems.

>Click on http://www.earthweb.com for FREE articles, tutorials,

>and discussions from the experts.




>$subst('Email.Unsub')

>



_________________________________________________________________________

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.



Share information about yourself, create your own public profile at 

http://profiles.msn.com.

Return to Index

P2P Archives