This article provides details for setting up an AcuXDBC database as a MSSQL Linked Server.
Problem:
There is a need to access the AcuXDBC database through MSSQL Server. How is that accomplished?
Resolution:
One method is to import the data using the MSSQL Server Data Transformation Services (DTS). However, the preferred method is to set up a Linked Server, which provides access to the live data rather than the snapshot created by importing.
After installing and configuring AcuXDBC and/or AcuXDBC Server and setting up a system DSN, set up the MSSQL Linked Server as follows:
(These instructions are specific to MSSQL Server 2005 and may be slightly different for other versions. The basics are the same.)
- Start the MSSQL Management Studio.
- Expand Server Objects.
- Right-click on Linked Servers and select New, Linked Server.
- In the New Linked Server dialog enter a name in Linked Server:
- Select Other data source if it isn’t already.
- In Provider select Microsoft OLE DB Provider for ODBC Drivers.
- In Product Name enter “AcuXDBC”.
- In Data Source enter the name of your system DSN.
- Click OK to save it all.
The Linked Server is now set up. One way to query it is to use the Openquery format. To view a table the query will look something like:
select * from openquery(LinkedServerName, ‘select * from tablename’)
