SQL Server 2005 and Oracle Instant Client 10.2.0.3

Tech-Archive recommends: Fix windows errors by optimizing your registry

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 from http://www.teranews.com

.

Relevant Pages

  • Re: problem connecting to db.
    ... the server and the client are at the same machine (the process is ... The VB6 client and the server are on the same machine, ... Oracle server software using one, and the Oracle client using the ... Look at the services on the server to verify that the Oracle Listener ...
    (comp.databases.oracle.misc)
  • Re: problem connecting to db.
    ... Have you checked the listener log file on the database server? ... client is correct, and that the connection string that you are ... the Oracle client would be looking for a server ...
    (comp.databases.oracle.misc)
  • RE: Help Needed: DBI (no error string)
    ... > error on the server. ... You can also turn on tracing in dbi and at the sqlnet level to ... > Thanks for letting me know abt the oracle 9i client issue. ...
    (perl.dbi.users)
  • Re: ODBC-error ORA-12535: TNS:operation timed out when trying to connect to Oracle 9.2.0
    ... I'm trying to connect to an Oracle 9.2 database via TCP from Microsoft ... Microsoft Windows Server 2003 SP1 ... Try with SQL*Plus on your client! ...
    (comp.databases.oracle.misc)
  • Re: I cant find a SETUP.EXE in the SQL Plus Client ??
    ... else's server for testing some SELECT statements I'm writing for them. ... I just want a free client because I don't own the Oracle license. ... How do I get a free Oracle client installed, if possible, so I can test some SQL statements. ... There is no documentation with that download. ...
    (comp.databases.oracle.tools)