May 11, 2005 at 5:03 pm
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.
May 13, 2005 at 1:48 am
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...
May 13, 2005 at 7:29 am
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
July 18, 2007 at 9:17 am
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?
_________________________
July 18, 2007 at 9:56 am
neotokyo,
Did you get the ODBC set up and working?
Steve
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply