Spec :
- Visual Studio .NET 2003
- Informix 9.2
- Informix Connect 2.7
- IIS 5.0
- Grant Administrators Privilage to user IUSR_WIN (Internet Guest Account)
- Run on WinForm : OK
- Run on WebForm : Error -> "XIX000:-25596:The INFORMIXSERVER value is not listed in the sqlhosts

file or the Registry."

Code :
WinForm : Success
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles

MyBase.Load
Dim strConn As String = "Provider=Ifxoledbc;User ID=informix;Data

Source=""brcdoc@ol_moon"";Extended Properties=;Persist Security Info=True;Password=informix"
Dim conn As New OleDb.OleDbConnection(strConn)
Dim strSQL As String = "select * from case "
Try
conn.Open()
Dim da As New OleDb.OleDbDataAdapter(strSQL, conn)
Dim ds As New DataSet
da.Fill(ds, "Test")
DataGrid1.DataSource = ds
Catch ex As Exception
Dim err As String = ex.Message
End Try
End Sub

WebForm : Error
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles

MyBase.Load
Dim strConn As String = "Provider=Ifxoledbc;User ID=informix;Data

Source=""brcdoc@ol_moon"";Extended Properties=;Persist Security Info=False;Password=informix"
Dim conn As New OleDb.OleDbConnection(strConn)
Try
ifxConnection.Open()
Dim da As New OleDb.OleDbDataAdapter("select * from case", conn)
Dim ds As New DataSet
da.Fill(ds, "Test")
Catch ex As Exception
Dim ee As String = ex.Message
End Try
End Sub

Thanks so much

Hi,

If the drivers bundled within "Informix Connect" has been installed and configured properly, the environment values supposed to set for the backend connection, gets updated in the Registry on Windows.

This message basically informs that an environment/registry value for INFORMIXSERVER, the default instance where the request should go, on connection is either missing or undefined.

To sort this out, follow:
Start - Programs - Informix - Informix Setnet32 - Environment - INFORMIXSERVER=
or similar option, and specify the informix instance name, when applied the registry gets updated.

Regards,
Shriyan

Thanks a lot.

Now I work fine both WinApp and WeBApp.

My Solution ,I update 'Machine.config' file ($\WINDOWS\Microsoft.NET\Framework\v1.1.4322\CONFI G) in <processModel> section . I change userName form 'MACHINE' to 'SYSTEM'.

Good Luck.