tags:

views:

1043

answers:

4
+1  Q: 

Connecting to Informix database from .Net

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.

+2  A: 

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.

smink  2008-10-10 18:14:59
A: 

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.

BFree  2008-10-10 18:18:28
A: 

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

Dana  2008-10-10 18:19:12
A: 

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/

Tim Haynes  2009-11-18 12:48:51

related questions

Displaying Flash content in a C# WinForms application
How to get the value of built, encoded ViewState?
Unhandled Exception Handler in .NET 1.1
How do I connect to a database and loop over a recordset in C#?
How do I most elegantly express left join with aggregate SQL as LINQ query
Get a new object instance from a Type in C#
.NET Testing Framework Advice
Automatically update version number
What is the difference between an int and an Integer in Java/C#?
How to write to Web.Config in Medium Trust ?
WinForms ComboBox data binding gotcha
How do you sort a C# dictionary by value?
Adding Scripting functionality to .NET applications
Floating Point Number parsing: Is there a Catch All algorithm?
How do I print an HTML document from a web service?
Decoding T-SQL CAST in C#/VB.net
Anatomy of a "Memory Leak"
How do I get a distinct, ordered list of names from a DataTable using Linq
Reliable Timer in a Console Application
How do I fill a DataSet or a DataTable from a LINQ query resultset ?
What's the difference between Math.Floor() and Math.Truncate() in .NET?
How do I calculate relative time?
How do I calculate someone's age in C#?
Are there any conversion tools for porting Visual J# code to C#?
When setting a form's opacity should I use a decimal or double?