Connecting Informix from SQL Server database

• Jean-Pierre LACOSTE

  Old Hand

  Points: 356

  More actions

  May 11, 2005 at 5:03 pm

  #167059

  Is it possible in a stored procedure to connect an informix database ? I would like to read datas from an informix table to insert them in a sql server one.

  Thank you for your help.

• jcfilth

  SSC-Addicted

  Points: 447

  More actions

  May 13, 2005 at 1:48 am

  #558619

  Yes, it's posible. You have to define a "Linked server". SQL Server Enterprise Manager-> <Your server> -> Security -> Linked Servers

  You can use a working ODBC defined connection as the Datasource (Microsoft OLE DB provider for ODBC driver). Then take a look at the security tab and match a local sql account with a Informix account.

  Take a look at the books online...

• steve block

  SSCertifiable

  Points: 7698

  More actions

  May 13, 2005 at 7:29 am

  #558703

  If you are looking at migrating data, dts works good.  I migrated from Informix to SQL-Server a few years ago.  Like jcfilth said, you need an ODBC driver set up to do it.

  Steve

• neotokyo

  SSCertifiable

  Points: 7239

  More actions

  July 18, 2007 at 9:17 am

  #720403

  i'm having trouble actually setting this up.

  don't suppose there is a quick 'how-to' out there written specifically

  for setting up a linked server to informix? i've got a user account here,

  and thats about it.

  don't know anything about informix though.

  thoughts?

  _________________________

• steve block

  SSCertifiable

  Points: 7698

  More actions

  July 18, 2007 at 9:56 am

  #720426

  neotokyo,

  Did you get the ODBC set up and working?

  Steve