I'm doing some testing on linked servers. I have 2 MS SQL server and 1 Oracle 8 server. The link between the two SQL server is not a problem. For the oracle server it seems to be. I can see the Oracle server under the item 'linked servers'. I even can see the tables. But if I try to do a query on it, it always gives back an error.
select * from ORA1.Tables.sales
gives a error
SERVER:MSG 208, Level 16, State 1, Line 1
Invalid object name 'ORA1.tables.info'
Can someone help with this
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!