August 8, 2008 at 6:32 pm
Hello All,
I am new to SQL server. We have a requirement to read Oracle and Postgres data from SQL server 2000. I am not sure about the steps to follow in creating the DBLink in SQL Server to read the data from external RDBMS. Pls help.
If it is a frequently asked query please point me to the right link.
Thanks
Rock
August 8, 2008 at 8:31 pm
Lookup linked servers in Books Online. What you are going to need to do is install the ODBC drivers for Oracle and Postgres on the server, then setup your linked servers. Once setup, you can then use four-part naming to access data on the linked server.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 9, 2008 at 11:38 am
Hi Jeffery,
Appreciate that. I google'd and got the info. Managed to configure it. It works fine.
Thanks for the inputs.
Cheers
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply