Jan 30, 2008

Sql server Link server to Oracle DB

Link server

1 Enterprise manager console -> [server name] -> security -> linked servers -> add one linked server -> data source => tnsnames.ora entry




















2 filled the remote login and password













3 Then you can use sql statement from sql server query analyzer -> ex.
select * from test..system.aaa

0 意見: