"mrdenny" <mrdenny@discussions.microsoft.com> wrote in message
news:8C4F32C1-E536-499B-9FA2-09C2F0A367F8@microsoft.com...
>I have always used the full Oracle client when connecting to an Oracle
> server. Check the MSKB. There is a KB Article that covers how to
> manually
> set the reg key to make this work. The Oracle installer doesn't always
> set
> this reg key correctly, and often need to be manually set.
> --
> Denny
> MCSA (2003) / MCDBA (SQL 2000)
> MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration
> /
> Microsoft Office SharePoint Server 2007: Configuration)
> MCITP (dbadmin, dbdev)
>
>
> "Joe Blow" wrote:
>
>> Hello All:
>>
>> I posted this in microsoft.public.sqlserver but didn't get a response.
>> I am hoping someone here can answer this...
>>
>> 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 from http://www.teranews.com
>>
>>