Connecting to oracle

Hi...

I went to the page http://www.aspfaq.com/show.asp?id=2126 to check how to
connect to oracle...

So my string looks like this...
"Provider=MSDAORA.1;Password=PWD;User ID=HECTOR;Data
Source=SRV-QUEORA1-DEV1;Persist Security Info=True"

but when I try to connect, it gives me this message : Microsoft OLE DB
Provider for Oracle error '80004005'
and then it tells me that I don't have the client components installed...
but I have Oracle Client installed on my computer and I have TOAD software
to communicate with the Oracle DataBase...

Can someone help me...

HDumas

Re: Connecting to oracle

On Fri, 19 Nov 2004 09:25:14 -0500, "HD" wrote:

>Hi...
>
>I went to the page http://www.aspfaq.com/show.asp?id=2126 to check how to
>connect to oracle...
>
>So my string looks like this...
>"Provider=MSDAORA.1;Password=PWD;User ID=HECTOR;Data
>Source=SRV-QUEORA1-DEV1;Persist Security Info=True"
>
>but when I try to connect, it gives me this message : Microsoft OLE DB
>Provider for Oracle error '80004005'
> and then it tells me that I don't have the client components installed...
>but I have Oracle Client installed on my computer and I have TOAD software
>to communicate with the Oracle DataBase...
>
>Can someone help me...
>
>HDumas
>

A fewwquestions:

Can you connect using SqlPLus and using SRV-QUEORA1-DEV as the connect string?
Is that your TNSNAMES.ORA entry for the instance you are attempting to reach.
Is your Oracle Client correctly configured( In your path and Oracle_Home set?)
What version of Client and Database?

Re: Connecting to oracle

Thank you... I found the problem by researching the string in Google...

www.vbip.com/forum/topic.asp?id=6259 addresses this problem... and it has
nothing to do with the connection... All you have to do is unchecked and
rechecked the permissions given on the Oracle_Home folder.

Works fine now!



"Turkbear" a écrit dans le message de
news:7q1sp092gt38gb7s2316cojnfrte3bdkkv@4ax.com...
> On Fri, 19 Nov 2004 09:25:14 -0500, "HD" wrote:
>
> >Hi...
> >
> >I went to the page http://www.aspfaq.com/show.asp?id=2126 to check how to
> >connect to oracle...
> >
> >So my string looks like this...
> >"Provider=MSDAORA.1;Password=PWD;User ID=HECTOR;Data
> >Source=SRV-QUEORA1-DEV1;Persist Security Info=True"
> >
> >but when I try to connect, it gives me this message : Microsoft OLE DB
> >Provider for Oracle error '80004005'
> > and then it tells me that I don't have the client components
installed...
> >but I have Oracle Client installed on my computer and I have TOAD
software
> >to communicate with the Oracle DataBase...
> >
> >Can someone help me...
> >
> >HDumas
> >
>
> A fewwquestions:
>
> Can you connect using SqlPLus and using SRV-QUEORA1-DEV as the connect
string?
> Is that your TNSNAMES.ORA entry for the instance you are attempting to
reach.
> Is your Oracle Client correctly configured( In your path and Oracle_Home
set?)
> What version of Client and Database?
>
>
>