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
.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
|Next:||From: Gil||Date: 2004-01-30 14:50:31|
|Subject: ODBC with C++ on solaris|
|Previous:||From: Zbynek Houska||Date: 2004-01-29 21:38:14|
|Subject: Setting up ODBC interface|