How do I set up a linked server to Informix using Transoft ODBC driver?

Using SQL 2005.  Have a working System DSN set up using Transoft ODBC driver to an Informix database.  This database is running MISYS (medical practice management software).

I need to set up a linked server from SQL 2005 to this database.  I can't find any documentation on how to do this.  When I use MISYS Query (reporting tool), it uses two levels of authentication to open a catalog.  I have the full path to the catalog, and the user/password for the catalog and the user/pwd for the database.  How do I put these together in an sp_addlinkedserver command to make a working linked server?
Who is Participating?
Eugene ZConnect With a Mentor Commented:
if you ave a working System DSN set up using Transoft ODBC driver to an Informix database on sql server box:

use ssms or code

use Microsoft OLE DB Provider for ODBC -- ODBC data source

sp_addlinkedserver @server='[your_linkedserver_name]',
@srvproduct='Driver',@provider='MSDASQL', @datasrc='[name of your system DSN]';

set security
Eugene ZCommented:
also check
How to connect SQL Server 7.0 to Informix                                   
Brett_GerlachAuthor Commented:
That worked.  I set the security to logon using the database (not catalog) user and password for Misys Query.  I didn't need the catalog user/password anywhere.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.