C# Informix OLE connection

[sabev]

Hi All,

I'm am trying to set up a connection to an informix database using C# in Visual Interdev. It works with VB, so I know my drivers are ok.

I just can't seem to come up with the syntax anywhere.

This is what I have -

OleDbConnection InformixConn = new OleDbConnection("Provider=Ifxoledbc;DSN=informix7;User ID=me;pwd=mypass;database=test"
InformixConn.Open();

If fails on the .Open() with -

[OleDbException (0x80004005): No error information available: E_FAIL(0x80004005).]

Any help would be greatly appreciated.

 

[sabev]

Never mind, I got it.

The connect string should be -

OleDbConnection InformixConn = new OleDbConnection("Provider=Ifxoledbc;Data Source=test@online_live;User ID=me;password=mypassword"