Re: using pgsql-odbc with ASP and ADO

Jan Novak wrote:
> 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 .....

In your ODBC settings for the connection, check under the "Datasource"
page of the Advanced Options (page 1) - if your Data Type Options has
"Text as LongVarChar" checked (I think this is the default), then check
and see what "Max LongVarChar" is set to below it, in "Miscellanous"
(should be set to 8190 as default) - try bumping this number up.

On a related note - I have a question for everyone else:

If "Text as LongVarChar" is unchecked, what does the Text datatype come
back as? In other words, is there some way to set the ODBC driver to
ignore any sizing constraints? Leaving it as-is, and modifying a number
to a really large value (if you don't know how big a field will get),
while it should work, doesn't seem like the optimum way to do it...

Andrew Ayers
Phoenix, Arizona

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.