Informix and SQL Server

[José Luis Romaguera]

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.

[Bogdan Neagu]

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?)

[pv...@my-deja.com]

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.

[pe...@veraperez.com]

[pe...@veraperez.com]

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