Re: Connecting to oracle

From: HD (dumh_at_hotmail.com)
Date: 11/19/04


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



Relevant Pages

  • RE: Cant load Oracle.ppd
    ... > To: 'Jeff Urlwin' ... > I use this string to connect: ... > Have you installed the Oracle client software? ... > rebooted since installing the Oracle client? ...
    (perl.dbi.users)
  • Re: ADO - accessing oracle
    ... >> I have prepared an excel form for users in our company to get external ... The connection string references the ... >> connection object through any service provider drivers to oracle client ... The oracle client processes the sql string ...
    (microsoft.public.excel.programming)
  • Re: [Oracle][ODBC]Numeric value out of range.
    ... the problem started when I upgraded the oracle client (including oracle odbc ... driver) from 9i to 10g. ... Your message seems to imply that to_dateshould not require a string. ...
    (perl.dbi.users)
  • Re: [Oracle][ODBC]Numeric value out of range.
    ... the problem started when I upgraded the oracle client (including oracle odbc ... driver) from 9i to 10g. ... Your message seems to imply that to_dateshould not require a string. ...
    (perl.dbi.users)
  • MSDAORA connection from Excel macro
    ... a connection to an Oracle database. ... Looking on the Internet I have found that this users the "Microsoft OLE DB ... and if you use oracle's advanced security on the oracle client to ...
    (microsoft.public.data.oledb)