SQL Server - Need Help Linked server and Oracle publication

Asked By prathap chowdary on 09-May-12 03:30 AM
Hi,

This is Prathap......

I need information for Linked server and Oracle publication. actually i know how to create linked servers for sql servers.
But i want to know how to extract data from oracle database through linked server ?

and i need to know through replication......one option is available....oracle publication........

Please any one help me.......it is urgent requirement.......

Regards,
Prathap.
3407.
[)ia6l0 iii replied to prathap chowdary on 09-May-12 09:45 AM
Do you want to query a remote oracle database from SQL Server?
prathap chowdary replied to [)ia6l0 iii on 12-Jun-12 04:02 AM
Hi,

Thanks for your reply......
Now i have created Linked server for ORacle server.
like this way...........

EXEC sp_addlinkedserver @server = 'TestOraLink', @srvproduct = 'Oracle', @provider = 'OraOLEDB.Oracle', @datasrc = 'TESTDB'

EXEC sp_addlinkedsrvlogin 'TestOraLink', false, 'CMS', 'CMS', 'CMS'


or else GUI its very easy.......

Regards,
Prathap.
3407.