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

---

A linked server that will look to a data source pointing to your ISAM
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 ISAM files. An example
of setting up a linked server to ISAM 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 ISAM files.

I have created a linked server to my ISAM files but am unsure as to how
to query this. What SQL syntax should I use?

When you have the linked server set-up you can query this server by using
SQL from the query analyser within SQL server. The syntax of the query is
quite specific to issue a simple select statement against one of your files
the following can be used as an example (please replace any entries within
square brackets with your own parameters)

select * from [linked server name]...[database_table_name]

This should return all data back from the specified tables.

Applies To

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