Cannot connect to Informix from ASP.NET application.

Question

Hello folks.

I've installed the trial version of IBM Informix Dynamic Server 11.50 on my development laptop, for use with an ASP.NET 2.0 app I'm writing. I have created a couple databases and filled them with sample data but I cannot connect. This is the relevant section of code:

Dim facStr As String = System.Configuration.ConfigurationManager.ConnectionStrings("fact").ConnectionString  
conn.ConnectionString = facStr
Try
    conn.Open()
Catch ex As Exception

The exception is:

[Informix .NET provider][Informix]Server ol_srv_custom is not listed as a dbserver name in sqlhosts.

The full path to the sqlhosts file is:

C:\Archivos de programa\IBM\Informix\Client-SDK\etc\sqlhosts

Informix's environment variables:

INFORMIXSQLHOSTS=C:\Archivos de programa\IBM\Informix\Client-SDK\etc\sqlhosts

Contents of sqlhosts file:

ol_srv_custom olsoctcp *nb-desarrollo svc_custom

Connect string:

Host=*nb-desarrollo; Service=svc_custom; Server=ol_srv_custom; Database=fact; User Id=informix; password=****

Any ideas? Thanks in advance. Ernesto.

Answer 1

Have you tried creating an ODBC connection and testing that? Just to verify that you can connect from an external source? Apologies if that's how you connected to enter your sample data, I wasn't sure from your description.

Answer 2

ODBC doesn't work either. When I try to create the DSN the driver user interface asks me to select a "Server Name" from a combobox, but it's empty. In fact, the only way I have to connect to this Informix installation is using the console utility dbaccess, that's how I created the test databases and INSERTed the sample data. I'm not sure if this question still belongs in SO, maybe ServerFault might be more appropiate place to ask but I don't know how to move it.

Answer 3

I would also suggest you to create ODBC connection and test it. There is info how to do it with setnet32 (for older version): http://www.synametrics.com/ifmxODBC.htm

Answer 4

No es la primera vez que he visto esto pasar con el demo version de IDS. Cual es el valor de sqlhosts?