Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-25 : 22:47:13
|
Neil writes "SQL Linked Server - OLE DB Fault - connecting to Oracle
Hi,
I have a problem with an SQL Server Linked Server and OLE DB.
WinNT (SP6)
SQL Server 7 SP3 (7.00.961)
MDAC Version 2.6 RTM
Oracle Client 8.1.7
Oracle DB 8.0.6 (running on a Unix system)
I cannot read any data using the linked server from the Oracle Tables.
Using Query Analyser ...Example Program......
EXEC sp_addlinkedserver 'scs', 'Oracle', 'MSDAORA', 'scs01p' -- TNS Name is 'scs01p'
GO
EXEC sp_addlinkedsrvlogin 'scs', FALSE, NULL, 'digitron', 'digitron'
GO
SELECT * FROM scs..DIGITRON.NEILTEST1
This produces the following error........
(1 row(s) affected)
(1 row(s) affected)
Server added.
(1 row(s) affected)
(0 row(s) affected)
(1 row(s) affected)
Server: Msg 7370, Level 16, State 2, Line 1
One or more properties could not be set on the query for OLE DB provider 'MSDAORA'. The provider could not support a required property.
[OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]
Yet if I execute the following SP from QA.....
EXEC sp_tables_ex scs
I get a full system catalog / owner / table list!
....So I assume that the Linked Server is all OK.
I have also tried using the MS ODBC Driver for Oracle, this produces the same results.
I can access the data from the remote Oracle DB using the SQL*PLUS & ODBC Test Tools provided with Oracle.
Anyone any ideas?
Regards
Neil" |
|
|
|
|
|
|
|
Linked Server Error - Oracle - OLE DB 7370