Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2003
    Posts
    9

    Unanswered: Problem displaying text datatype from ASP

    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!
    Last edited by forte; 04-07-03 at 09:30.

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Can we have the Informix table layout of texttable?

    dbschema -t texttable -d database
    rws

  3. #3
    Join Date
    Apr 2003
    Posts
    9
    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.

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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!
    rws

  5. #5
    Join Date
    Apr 2003
    Posts
    9
    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

  6. #6
    Join Date
    Apr 2003
    Posts
    9
    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!

  7. #7
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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!
    rws

Posting Permissions

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