Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Unanswered: How to run informix on IIS & .NET ?

    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

  2. #2
    Join Date
    Jan 2004
    Posts
    3
    Thanks so much

  3. #3
    Join Date
    Nov 2003
    Location
    Mumbai, India
    Posts
    92
    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

  4. #4
    Join Date
    Jan 2004
    Posts
    3
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •