Informix and SQL Server
Jose Luis Romaguera asked how to set up an Informix linked server in SQL Server using sp_addlinkedserver and the OLE DB provider. Pedro Vera-Perez advised following the help examples and later connected Informix Redbrick to SQL Server 7 through the ODBC driver and DSN in Enterprise Manager. He then had odd OPENQUERY behavior with field lengths and asked for tips; none were given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello everybody I am trying to connect Informix as a linked server in SQL Server with Informix OLE DB Provider taken from the SDK. The problem is, I don't know the syntax or the parameters I must set, and I can't find any information. The SQL server procedure is sp_addlinkedserver. Does anyone have an example? Any help would be appreciated.
I think there is a sp_help or sp_helptext <procedure> that displays the code for a stored procedure (that was Sybase, but SQL Server was originally Sybase, no?) "José Luis Romaguera" wrote: > Hello everybody > > I am trying to connect Informix as a linked server in SQL Server with > Informix OLE DB Provider taken from the SDK. > > The problem is, I don't know the syntax or the parameters I must set, and I > can't find any information. > > The SQL server procedure is sp_addlinkedserver. Does anyone have an example? > > Any help would be appreciated.
The help item for sp_addlinkedserver will give you examples on how to do it. In a day or two I am doing a connection just like you are asking, so I can give you a better answer. Basically follow the instructions and tell it you are talking to the Microsoft OLE DB Provider for ODBC. Pedro A. Vera-Perez http://veraperez.com Sent via Deja.com http://www.deja.com/ Before you buy.
The help item for sp_addlinkedserver will give you examples on how to do it. In a day or two I am doing a connection just like you are asking, so I can give you a better answer. Basically follow the instructions and tell it you are talking to the Microsoft OLE DB Provider for ODBC. Pedro A. Vera-Perez http://veraperez.com Sent via Deja.com http://www.deja.com/ Before you buy.
As promised, here's an update: I managed to connect the Informix Redbrick to SQL Server 7. In my case I did not need to call the stored procedure, I just went to the Enterprise manager, specified the ODBC driver and the DSN and it let me connect. If you do it with SQL server 2000 then you need the stored procedure. The problem now is that I don't know the proper way to query the tables :-( I should be able to use SELECT * FROM OPENQUERY(LINKED_SERVER,'query for linked server goes here') but I am getting some weird behaviors, like for example SQL server expects a field with 10 characters and it gets 4. Cheesy. The customer is going to provide us with 5 query templates that we will use to pull the Redbrick data. Other from that we are kept in the dark. Anybody knows any traps, common mistakes, etc. you want to warn me while trying to query this linked server? Thanks! Pedro A. Vera-Perez http://www.elfinc.com Sent via Deja.com http://www.deja.com/ Before you buy.