Connecting to Informix database from .Net

3
votes

What's the best way to connect to a Informix database from .Net?

I'm developing a client-server application based on a legacy Informix DB which used to be connected by JDBC.

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

  1. To be fast
  2. DB server changes not needed
  3. No ODBC and no dependencies, other than de .Net Framework 2.0

Thanks in advance for your help.

4
c#.netdatabase-connectioninformix
Please select the answer that helped you most - if any of them helped at all. – Jonathan Leffler

4 Answers

6
votes

The connections strings to use with OleDb or ADO.NET can be found here.

Take a look at this article on how to connect to an Informix database using ADO.NET.

1
votes

We connect to Informix from .NET, but we do it via web services that are written in FourJ's BDL

0
votes

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 those? Those might work.

0
votes

You might like to investigate OpenLink's Multi-Tier Informix driver for ADO.Net (just install everything on the client): http://uda.openlinksw.com/dotnet/mt/dotnet-informix-mt/