Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQl to Oracle query part 2
The query: select * from localoracle..system.country gets me OLE DB provider 'MSDAORA' does not contain table '"system"."county"'. In SQL Server Enterprise Manager Using the Linked Servers utility under Security I can 'see' the table. I linked using the 'system' id and...- rchalker
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
SQl to Oracle Query
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...- rchalker
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
SQL7 and Oracle link
In creating a SQL7 link to an Oracle DB; what is the difference in ServerName and MyServer in the below listed link syntax? My machine name is Box, the connection string is local.domain, the database name is myName, what goes where? example: EXEC sp_addlinkedserver @server = 'Servername'...- rchalker
- Thread
- Replies: 0
- Forum: Oracle: All versions
-
Linking SQL7 to Oracle
How can I link SQl7 to Oracle using T-SQL? I keep getting a 7399 error message.- rchalker
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
