How connect and read using a Linked Server?
Posted on 2009-12-19
At work we mainly use MS SQL Server and VB 6 to develop applications. Recently I have been asked to write a small VB 6 application to allow a user to retrieve some records on a regular basis from a Linked Server that is connected to some Oracle tables.
Although I have written many VB 6 apps that read and write to MS SQL Server, I have not used a Linked Server in any read and write operation. The linked server appears under the Security section of one of our SQL Groups.
Can someone please provide some information or example of how to set up the connection and recordset and command to read from the Linked Server tables?