Re: Oracle OLE Providers Please Help

From: tore <TBostrup_at_teamia.com>
Date: Sat, 26 May 2001 02:52:57 -0400
Message-ID: <mpIP6.38$yH.2244@client>

Use PROVIDER=MSDAORA;...

HTH,
Tore.

"Jimi" <Jimi_at_NOSPAM.com> wrote in message news:CU1O6.1688$Ld4.72719_at_ozemail.com.au...
> Hi,
>
> I am using Oracle OLE providers to access a local Oracle instance, what i
> was wondering is if i have to access the same instance across a network
 can
> i still use the same providers? For example these providers work really
 well
> when i try to access the instance from a webserver on the same machine,
> however if i try to access an instance of Oracle from a remote location
> using the OLE providers I can't seem to make a connection, I have checked
> the configuration eg. TNSNAMES etc and i can connect through SQL PLUS with
> no problems. I have pasted the error code & the connections string that i
 am
> using.
>
> Sean
>
>
> <!---------------------------------- Error
>

 Code -----------------------------------------------------------------------


> ------------------

>
> OraOLEDB error '80004005'
>
> Unspecified Error
>
>
>
>
> <! Connection
>

 String ---------------------------------------------------------------------


> --------------------------------------------------------------------------

 -
>
> strConnection="PROVIDER=OraOLEDB.Oracle;DATA SOURCE=instance_name;USER
> ID=User;PASSWORD=Pass;PLSQLRSet=1"
>
>
Received on Sat May 26 2001 - 01:52:57 CDT