Can't view Informix Database Table

[b98mr1]

I have just landed a project that requires a connection to an Informix database (of which I have no experience). Using Visual Studio 2005, I am able to create a connection in Server Explorer using the System DSN I created but I cannot see any tables. The System DSN uses the Informix 3.80 32BIT driver.

I know there's something easy I am missing here and so if anyone has any experience of connecting to Informix databases using .NET, could you point me in the right direction.

Many Thanks

 

[dcampo]

Use OleDb for Informix

Rewiew the site:

http://www.connectionstrings.com

 

[thendrickson]

I also suggest checking out the newest Informix drivers.

I have the IBM site bookmarked but on my work pc so I can post it Monday if you need it.

My exeperience was setting upa linked server in SQL Server 2000 so there myay be differences, but I had very many problems before I managed to get straight.

dcampo is correct about using OLeDB, I think.

My experience using DSN connections to an Informix database have not been good.

Just be aware that 3 months ago or so, I had never touched an Informix database, but I was able to set up a linked server that works very well.

If you like, I will post my procedure Monday (it is on my pc at work)