New answers tagged odbc
Try Open query BEGIN TRANSACTION; select top 10 * INTO #t from openquery ("YOUR LINKED SERVER NAME",'SELECT * FROM [SOURCE TABLE NAME]); COMMIT
If you want to connect your java software to a Oracle DB, I recommend you to use JDBC API instead http://docs.oracle.com/javase/tutorial/jdbc/basics/index.html You are welcome. PS- ask for help to your IT-team/DBAs
A linked server is referenced just like you would reference a database, with multi-part naming - LinkedSvrName.DBName.SchemaName.ObjectName. There isn't really anything else to "accessing" a linked server. There are some settings you will need to be cognizant of to ensure you can return data; RPC and RPC Out for instance. Also you will want to use ...
Top 50 recent answers are included