using pgsql-odbc with ASP and ADO - Mailing list pgsql-odbc

From Jan Novak
Subject using pgsql-odbc with ASP and ADO
Date
Msg-id 001d01c3e6cc$8bf56d20$0100a8c0@gamedonald
Whole thread Raw
List pgsql-odbc
Hi,
i'm using pgsql-odbc driver for connection to my postgres sql server and everything works fine.
But today i made some application with text areas with large content (>32kB) and i'm in trouble ....
 
If I just fetch data from database
    set objRS = Connection.execute "SELECT * FROM ""table"" where id=23"
and use them : response.write objRS("largeConent")
i get displayed only something like 8kB of data.
 
When i tried using objRS("fieldName").getChunk(objRS("fieldName").actualSize) i got an error message : ADODB.Field error '800a0c93', Operation is not allowed in this context.
.actualSize contains correct value and i even tried using .getchunk(100) with same result every time ....
 
 
Does anyone seen this before ? It's quite important for me, cause i'd like to use postgres sql server as backend server for many other applications, but many of them will be IIS5+ with vbScript, so if i'm not able to use large data i have to try something else :-(, and i don't want to .....
 
Thanks for any hint or advice,
 
Bye, Honza Novak

pgsql-odbc by date:

Previous
From: brightoceanlight@hotmail.com (Gil)
Date:
Subject: ODBC with C++ on solaris
Next
From: "Dave Page"
Date:
Subject: Re: where's the build environment for odbc