Re: Connecting to oracle
From: HD (dumh_at_hotmail.com)
Date: 11/19/04
- Next message: kevin bailey: "Re: call run or execute a DTS package from an APS (aspx) page"
- Previous message: kevin bailey: "Re: call run or execute a DTS package from an APS (aspx) page"
- In reply to: Turkbear: "Re: Connecting to oracle"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 19 Nov 2004 13:33:53 -0500
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" <noone@nowhere.com> a écrit dans le message de
news:7q1sp092gt38gb7s2316cojnfrte3bdkkv@4ax.com...
> On Fri, 19 Nov 2004 09:25:14 -0500, "HD" <dumh@hotmail.com> 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?
>
>
>
- Next message: kevin bailey: "Re: call run or execute a DTS package from an APS (aspx) page"
- Previous message: kevin bailey: "Re: call run or execute a DTS package from an APS (aspx) page"
- In reply to: Turkbear: "Re: Connecting to oracle"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|