Unanswered: handling the text datatype from asp.net
We are building a web application using asp.net. We are using the informix odbc driver version 3.81. Informix database version 7.3.2.
We have created a stored procedure to insert data into a table. The table has a field of "text" datatype.
I am unable to insert data into this field. It seems, Problem has to do with resolving the datatype.
For those familiar with .NET, following is the syntax i am using to describe the field in the stored procedure call that i am making:
Dim textcol As OdbcParameter = New OdbcParameter("",OdbcType.Text)
textcol.Value = "dummy text"
OdbcType.Text is supposed to match up with the informix Text datatype, but there seems to be a problem.