Connecting to an Informix Database from .Net

Question

What is the best way to connect to an Informix database from .Net?

I am developing a client-server application based on an outdated Informix database that was connected by JDBC.

I need this, from the most important to the least:

• To be fast
• No changes to the database server needed
• No ODBC and no dependencies except .Net Framework 2.0

Thanks in advance for your help.

Answer 1

Connection strings for use with OleDb or ADO.NET can be found here .

Check out the article on how to connect to an Informix database using ADO.NET.

Answer 2

Informix .NET, -, FourJ BDL

Answer 3

http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.relnotes.doc/uc3/netrel.htm

See if that helps. Also, what about the built-in ODBC or OLEDB drivers? Have you tried them? They can work.

Answer 4

Perhaps you should study the OpenLink Multi-Tier Informix driver for ADO.Net (just install everything on the client): http://uda.openlinksw.com/dotnet/mt/dotnet-informix-mt/