This article provides details for setting up an AcuXDBC database as a MSSQL Linked Server.
There is a need to access the AcuXDBC database through MSSQL Server. How is that accomplished?
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.)
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’)