I have a linked server set up in Microsoft SQL 2000 Server. When I open up the tables in the Linked Server section under security, I see all my tables, but can't go further than that. How do I perform queries onto the data so I can view the actual data records?
This is the properties set up in the linked server:
Linked server: SWDATA
Provider Name: Microsoft OLE DB Provider for ODBC Driver
Product name: Demo Files
Data source: ODBC;DSN=Demo Files;RemotePort=20222;SERVER=NotTheServer
Provider string: DRIVER={AcuODBC Driver};SERVER=NotTheServer
Location:
Catalog:
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.