| Unable to fetch data from oracle using the SQL server [message #202036] |
Tue, 07 November 2006 23:01 |
jesuisantony
Messages: 166
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)".
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
