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