Any ideas how to connect to an Informix DB?

I need to use the an OLE DB Provider to create a Linked Server using a ODBC-Connection (Informix). I know that I cannot see many things in the Providers drop-down list. Has anyone created a linked server like this one? I mean SQL 2005 (Standard Edition) x64 and Informix. 10x in advance.

Hi sageata2002,

I've got the same problem, and still searching the solution.

Perhaps we have to downgrade to SQL-Server 2005 x86 (32bit), where the MSDASQL-Provider (OLEDB Bridge for ODBC) is available....

|||

Hello.

I am waiting for an answer from a company named Openlink, since they told me they will provide the solution in couple of days (their driver is still in beta). I will keep anyone posted about this, and, if successful, I will provide the details (my understanding is that the same procedure will apply to Oracle, for example).

|||

Can you inform me, as soon as the Openlink-Solution is available?
That would be greatful!

Thank you very much.

Heiko Stahl
Systemadministrator
TQ-Systems GmbH

Heiko.Stahl@.tqs.de
http://www.tq-group.com

|||Of course I'll provide any useful news as soon as they will arive. I want this solved and shared with the rest of us, so we don't have to be at Microsoft's mercy; or any other giant for that matter|||

In the meantime I have contacted OpenLink, too.

I got a evaluation-version of an OLEDB-Provider for ODBC.

(download here:
http://download.openlinksw.com/uda/open60/wil6zole.msi ;; IA64
http://download.openlinksw.com/uda/open60/wal6zole.msi ;; AMD64
)

Unfortunately this Bridge works only with 64bit ODBC drivers, but our Informix SE is only 32 bit.

I must downgrade the SQL-Server to 32bit, no other way can help.

Regards,

Heiko