Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1259
  • Last Modified:

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?
0
Brett_Gerlach
Asked:
Brett_Gerlach
  • 2
1 Solution
 
Eugene ZCommented:
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_addlinkedserve
http://msdn.microsoft.com/en-us/library/ms190479.aspx

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

set security
sp_addlinkedsrvlogin

http://msdn.microsoft.com/en-us/library/ms189811.aspx
0
 
Eugene ZCommented:
also check
How to connect SQL Server 7.0 to Informix                                           

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=243&lngWId=5
0
 
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.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now