Has anyone tried connecting to Informix from ADO.Net? What provider should be used? When i use MSSQLDB; it is giving error.
Please help me.

Thanks in advance.

It's not really tested yet, but some customers succeeded in connecting to .net with the Client Software Development Kit (CSDK) version 2.80.
It contains the latest updates for OLEDB.

I have installed the same. But it gives the following error when opening the connection. I am not sure, it is because of CSDK or .Net.

Do you have any idea?

Following is the error:

Non-NULL controlling IUnknown was specified, and either the requested interface was not IUnknown, or the provider does not support COM aggregation.

I'm sorry, I'm not really a Microsoft fan, nor expert.
Are there any Informix Errormessages where we can work on?
Did you try a trace of the messages between client and server?

Do you receive this error message when you try to establish a connection or are you running a sql command at that point ? Which provider are you using ?

The error is occured when we try to establish connection.The error and provider details are mentioned in attached "error.doc".

The error in your posted document is different than "Non-NULL controlling IUnknown was specified, and either the requested interface was not IUnknown, or the provider does not support COM aggregation.". When did you receive the IUnknown error ? Have you tried accessing the informix server from vb 6 (if you have it) ?

Have you tried to create a dsn connection instead ?

I just tried the following.
I installed Informix Client SDK 2.80 and it is doing fine at this moment.

But need to be tested when i start actual coding. As of now, its ok.

Thanks.