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

Easysoft ODBC-RMS Driver

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

Article :	00644
Last Reviewed :	19th July 2005
Revision :	1

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-RMS Driver

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)

Easysoft ODBC-RMS Driver

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

Applies To

Knowledge Base Feedback