Home » RDBMS Server » Networking and Gateways » Unable to fetch data from oracle using the SQL server
Unable to fetch data from oracle using the SQL server [message #202036] Tue, 07 November 2006 23:01
jesuisantony
Messages: 132
Registered: July 2006
Location: Chennai
Senior Member
Dear All,

We are tring to fetch the data from an Oracle database using the query in the MS SQL server. But it throws some error druing the exceution. Can someone help me on this?

Query :

select * from
OPENROWSET ( 'MSDAORA.1'
, 'ABC.XYZ' ; 'User_ID' ; 'password'
, 'select * from UXA.UDBER_RPT '
) as A

Error :

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDAORA.1" for linked server "(null)" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "MSDAORA.1" for linked server "(null)".
Previous Topic: Oracle 10g XE and tnsnames.ora
Next Topic: WB_RT tables in OWB
Goto Forum:
  


Current Time: Mon Dec 05 12:34:17 CST 2016

Total time taken to generate the page: 0.09297 seconds