Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Blobs with PB 8 and MSSQL 7

10 views
Skip to first unread message

Marc Whitney

unread,
Jul 19, 2003, 12:49:17 AM7/19/03
to
I am using PB 8 Enterprise on Win 2000 with MS SQL 7.0, connected with ODBC
ver 3.52 and have a blob var of 18 meg in my pb app. Autocommit = true with
my SQLCA transaction object but I am not getting to updateblob or selectblob
to set or retrieve my entire blob. Only the first 32767 bytes are returned
from my selectblob. My pb script works great with ASA 8.0 but not MS SQL 7.

Any suggestions would be greatly appreicated.

Thanks in advance
Marc


WS

unread,
Jul 21, 2003, 8:39:38 AM7/21/03
to
this is faq. you need to set maxtextsize for blob columns.. search here in
the newsgroups

"Marc Whitney" <marc.w...@mwisolutions.com> wrote in message
news:epzRPOcTDHA.298@forums-2-dub...

0 new messages