Skip site navigation (1) Skip section navigation (2)

using pgsql-odbc with ASP and ADO

From: "Jan Novak" <jan(dot)novak(at)interbis(dot)cz>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: using pgsql-odbc with ASP and ADO
Date: 2004-01-30 01:01:08
Message-ID: 001d01c3e6cc$8bf56d20$0100a8c0@gamedonald (view raw or flat)
Thread:
Lists: 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

Next:From: GilDate: 2004-01-30 14:50:31
Subject: ODBC with C++ on solaris
Previous:From: Zbynek HouskaDate: 2004-01-29 21:38:14
Subject: Setting up ODBC interface

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group