Re: connecting to informix

from a web.config file I use: <add key="Conn1" value="database=db1; HOST=192.168.0.1; server=db_engine_tcp; service=1492; protocol=onsoctcp; UID=informix; password=passwd;DELIMIDENT=n;Pooling=False;" /> and some sample/test code: Dim myConnectionString As New String (System.Configuration.ConfigurationManager.AppSettings("Conn1")) Dim myConnection As New IBM.Data.Informix.IfxConnection (myConnectionString) myConnection.Open() Dim SqlQuery As String SqlQuery = "select * from a1 " Dim myCommand As New IBM.Data.Informix.IfxCommand(SqlQuery, myConnection) myCommand.CommandTimeout = 0 Dim myDataAdapter As IBM.Data.Informix.IfxDataAdapter myDataAdapter = New IBM.Data.Informix.IfxDataAdapter(SqlQuery, myConnection) myDataAdapter.SelectCommand = myCommand myDataAdapter.SelectCommand.CommandTimeout = 0 Try myDataAdapter.Fill(myDS, "test") 'Me.GridView1.DataSource = myDS.Tables("test") 'Me.GridView1.DataBind() Catch ex As Exception Response.Write("Error: " & ex.Message) Finally myCommand.Dispose() myDataAdapter.Dispose() myConnection.Dispose() End Try