On Jun 29, 6:58 am, "Joe Blow" <jb...@aol.com> wrote:
> Hello All:
>
> Having some problems with the Oracle Instant Client 10.2.0.3 and SQL Server
> 2005.
> WinXP Pro on a very fast PC, 3 Gig RAM, plenty of HD space.
> I already got past the problem of turning on "OPENROWSET" in the "Surface
> Area Configuration".
>
> I wrote this sql statement to download a table from Oracle and insert into
> my table.
>
> USE DatabaseName;
> TRUNCATE TABLE MyTableName
>
> SELECT * INTO MyTableName from OPENROWSET ('MSDAORA', 'ORA_Instance';
> 'username';'password','SELECT FIELD1, FIELD2, FIELD3, etc FROM
> Oracle_Table_Name')
>
> I get the following error message:
>
> OLE DB provider "MSDAORA" for linked server "(null)" returned message
> "Oracle client and networking components were not found. These components
> are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3
> or later client software installation. Provider is unable to function until
> these components are installed."
> Msg 7303, Level 16, State 1, Line 3
> Cannot initialize the data source object of OLE DB provider "MSDAORA" for
> linked server "(null)".
>
> I have the following envrionment variables set as well:
>
> TNS_NAMES=C:\Oracle\InstantClient (where my tnsnames.ora and
> sqlnet.ora files are stored...)
> ORACLE_HOME=C:\Oracle\InstantClient
> PATH=%PATH%;C:\Oracle\InstantClient
>
> It almost looks like it's not seeing the client at all.
> However, I can create DSN entries and use those with MS-Access.
>
> Also, I can connect to the Oracle server with SQLPlus using the "SQLPLus
> username/password@instance" without issues.
>
> However, if I launch SQLPlus and do not use the username/password@instance
> format,
> it asks me to login with a username and password, then I get an error:
> ORA-12560: TNS:protocol adapter error
>
> Do I need to install the full 10g Oracle Client or can I use the Instant
> Client?
>
> Please help and TIA !!!
>
> -Joe
>
> --
> Posted via a free Usenet account fromhttp://www.teranews.com