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?