Easysoft.com Documentation Knowledge Base Products  |  Solutions  |  Support  |  Applications  |  Developer  |  Company

---

A linked server that will look to a data source pointing to your RMS files can be set up quickly through the Query Analyser within SQL server. We have found the best way to add them is to use inbuilt stored procedures. One thing that you need to make sure is that you have a valid system DSN (using the Easysoft ODBC driver) pointing to your RMS files. An example of setting up a linked server to RMS is as follows (please replace parameters within square brackets with your own parameters):

exec sp_addlinkedserver @server='[name_of_linkedserver]',
@srvproduct='Easysoft Driver',@provider='MSDASQL', @datasrc='[name of system DSN]';

When this query is actioned it will create a linked server that will be able
to query your RMS files.

Applies To

• Products
  • Easysoft ODBC-RMS Driver
• Applications
  • Microsoft SQL Server