Connecting with Informix.

Topics: Data Access Application Block
Aug 13, 2010 at 3:39 AM

Hi All,

How can I connect to informix with DAAB. Is there any provider for Informix in EntLib 5.0?

I tried....
private Database _dbInformix = new GenericDatabase("Provider=Ifxoledbc;Data Source=XXXX;User ID=XXXX;Password=XXXX;OLEDB Services=sqlexec; Connection Timeout=100;", OdbcFactory.Instance); 

But when the connection was opened I got the error message

"ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

So please help me with provider code (if any) for connecting to informix db or get me the syntax.

Thanks in advance


Senthil Prabhu

Aug 13, 2010 at 4:16 AM

It seems like you're using the connection string for the IBM Informix .NET Provider.  If you want to use the ODBC provider in .NET, the format is different.  See this link.


Sarah Urmeneta
Global Technology and Solutions
Avanade, Inc.