Re: SQL Server 2005 and Oracle Instant Client 10.2.0.3

I searched the MS KB, but could not locate any articles regarding this
issue.

Could you point me in the right direction?


Thanks Mr Denny.


-Joe



"mrdenny" <mrdenny@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8C4F32C1-E536-499B-9FA2-09C2F0A367F8@xxxxxxxxxxxxxxxx
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





--
Posted via a free Usenet account from http://www.teranews.com

.

Relevant Pages

  • Re: Top Vulnerabilities to Windows Systems
    ... >> vulnerable just by connecting to the Net as a client. ... > run Linux systems on the net with the same level of understanding as they ... > often running many server type services, and the user runs as root just ... > There are just as many technical users in both camps, but as the installer ...
    (microsoft.public.windowsxp.general)
  • 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)