SQL Server 2005 and Oracle Instant Client 10.2.0.3
- From: "Joe Blow" <jblow@xxxxxxx>
- Date: Fri, 29 Jun 2007 09:10:52 -0700
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
.
- Follow-Ups:
- RE: SQL Server 2005 and Oracle Instant Client 10.2.0.3
- From: mrdenny
- RE: SQL Server 2005 and Oracle Instant Client 10.2.0.3
- Prev by Date: Re: AAArgh! sp_addlinkedserver giving me fits
- Next by Date: RE: SQL Server 2005 and Oracle Instant Client 10.2.0.3
- Previous by thread: Re: SQL service manager
- Next by thread: RE: SQL Server 2005 and Oracle Instant Client 10.2.0.3
- Index(es):
Relevant Pages
|
