[forte]

Hello gurus, i salute you!

Having a HUGE problem displaying text data type with Informix:

Some specs:
- Informix 9
- CLI Informix 3.30
- IIS .net

CODE: test.asp
CONN_STRING = "DSN=workdsn;"
Set Conn_Informix = Server.CreateObject("ADODB.Connection")
Conn_Informix.Open CONN_STRING

qwe1="select desc from texttabel"

Set rs1 = Server.CreateObject("ADODB.Recordset")
set rs1=Conn_Informix.Execute(qwe1)

while not rs1.eof
label = rs1.FIELDS("desc").value
response.write label & "OK"
rs1.movenext
wend

RESULT:
EMPTY page with a bunc of OKs

Q:
- how do i get the data displayed? Heard of the texttoclob thingy but how do i use it?
- Is this a CLI problem?
- am able to display the result from dbaccess .....
- tried the same query with SQL server with same data types. No problems!

PLEASE HELP!

[Roelwe]

Can we have the Informix table layout of texttable?

dbschema -t texttable -d database

[forte]

thanks,
chartest char(100)
desc text

dbschema thingy:
{ TABLE "workdb".texttabel row size=156 number of colomns=2 index size =0}

create table "workdb".texttabel
(
chartest char(100),
desc text
);
revoke all on "workdb".texttabel from "public";

sorry about the texttabel typo error ... this was a test table....

thanks for the response, roelwe, have to admit were a bit worried when there were no responses. I'm have to opt for a char(30000) at the moment which is ridiculous and unhealthy.

[Roelwe]

Hi, first of all.

If you want to work with .net, you really nead the latest CSDK, 2.81.

You can download it for free at http://www.ibm.com/informix
What is the exact version of your Infromix server? 9.3, 9.4 ?

I found this in the OLEDB programming manual:
A server-side scrollable cursor (corresponding ADO flags: adOpen-
Dynamic, adOpenStatic, adOpenKeyset) cannot be opened if results
include simple large objects (BYTE and TEXT) or collections. You can
use server-side nonscrollable cursors (adOpenForwardOnly) or
client-side scrollable cursors (adUseClient) with these types.

Maye it might be interesting to test it with CLOB (smart blobs. You will have to define a smart blobspace for that. (onspaces)

Let's see what that gives us!

[forte]

thanks for the prompt reply!

hmmm, thanks for taking some time going through the manuals and I'll certainly try adOpenForwardOnly etc.

I have to tell you that i'm more of a web developer and less on the DB admin thingies, so I passed your recommendations to my collegues who are DB admins.

I'll certainly update you on any findings

[forte]

EUREKA!! U're sooo kewl! Thanks for posting out the adUseClient note because that's the solution.

Here's the full code for reference:
CONN_STRING = "DSN=workdsn;"
Set Conn_Informix = Server.CreateObject("ADODB.Connection")
Conn_Informix.Open CONN_STRING

qwe1="select desc from texttabel"

Set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.CursorLocation = 3 'JUST NEED THIS!!!
rs1.open qwe1,conn_informix

'set rs1=Conn_Informix.Execute(qwe1)

while not rs1.eof
label = rs1.FIELDS("desc").value
response.write label
rs1.movenext
wend

I wish the support that i get from the paid ones is like this. Informix put the blame on microsoft, and microsoft blames informix. In the end, a huge egg on the forehead. Thanks again sir!

[Roelwe]

Great news.

About the support issue...

I could look into that if you give me a case number. Beleive it or not, but we do want to give our customers good support!