SQl to Oracle Query

[rchalker]

I have successfully linked SQL7 to Oracle but I cannot get a linked query to work;

example: select emp.empno from localoracle..scott.emp emp

The passthrough query works;

example: select * from openquery (localoracle, 'select * from emp').

What is the correct syntax for getting a linked query, linked update/insert to work?

Thanks,
Rod

 

[foxdev]

localoracle..scott.emp

Its after lunch so my brain may be misfiring, but I think what you want is:

localracle.databasename.scott.emp

In my experience, the database name was required when using linked servers (though the owner can be defaulted if its dbo). Robert Bradley
Support operation moo!
Visit the OpCow page

http://www.agrainofhope.org/opcow.shtml

to help in this cause