Re: Oracle OLE Providers Please Help

firstly have you got the following in place.

Web server - oracle client and OLEDB provider installed and sqlplus working? It is this machine that makes the connection to the db, not the client.

secondly

the data source should be the tnsnames alias for the database (which is not necessarily the same as the instance name.

thirdly,

You are well advised to patch the oracle database and the web server client to the latest version for your release of the database. I'd normally also recommend that you patch the web server to the latest MDAC from MS, however we might be in a situation at work where this is causing us problems.

HTH

--

Niall Litchfield
Oracle DBA
Audit Commission UK



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

>

>