This scenerio may have been covered a couple of weeks ago, but I couldn't
locate the resolution on the LAZYDBA website.
I'm not finding any solid information for trouble shooting either.

1. I installed Oracle 9i Client, SQL*NET only.

2. Setup tnsnames.ora

3. Created Oracle account on remote: MIUSER

4. verified connectivity with oracle using SASP/MIUSER

5. create linked server/login called mi_dsn_test
provider name: Microsoft OLEDB Provider for Orcle (no oracle provider was
available in the dropdown)
product name: Oracle
data source: SASP
default login: miuser/********* (valid credentials)

6. attempted to access the server with this sql: select * from
mi_dsn_test..mi_user.mi_lead

7. received the following error:
"
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider 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.]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005: ].
"

Do the dba's have any thoughts on how to resolve this?

Jon Brewer
SunGard eSourcing
MidRange DBA Group
(856) 566-3474


|---------+-------------------------------------------------------->
| | "Chip Smith " |
| | <mssqldba-ezmlmshield-x64184562.[Email Address Removed] | azyDBA.com> |
| | |
| | 10/04/2004 02:57 PM |
| | |
|---------+-------------------------------------------------------->
>----------------------------------------------------------------------------------------------|
| |
| To: "LazyDBA Discussion" <[Email address protected] |
| cc: |
| Subject: Unpredictable Linked Servers |
>----------------------------------------------------------------------------------------------|




Here we are;
One server win2k, with 4 procs, 4g mem.
Named Instance 1 has a linked server connected to Oracle, no probs,
resultsets return as expected.
Named Instance 2 on same box says, "OLE DB provider 'MSDAORA' reported an
error.
[OLE/DB provider 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."
Same logins, same query's. (select * from xxx..ORACLE.DBTABLENAME) Fails on
one, works for the other. All mdac is current. SP3a loaded. Oracle client
9i
re-loaded. Box has been rebooted 12 to 15 times in the process of
unloading
and reloading sp's, mdac, oclients, etc....

Does anybody know how to troubleshoot this? All the reg entries are
identical. Is this an expected behavior? If we can ever get set up to be
able to repeatable connects to this Oracle box (which by the way, every
other sql server in my shop connects succesfully to), I could get this
stuff
done , and Oracle could be made to go away.....

Any feedback might help.

-- chip


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]






MS Sql Server LazyDBA home page