@Admin: "If anyone has experience in fetching a Blob field on MS-SQL(7) please have a
hthomas@example.net.
I am trying to fetch a Blob column (Image) from a MS-SQL(7) table.
The select terminates with and error:
"Could not allocate enough memory (-1 bytes) for column 1."
 it dies on line 14.
Thanks for any suggestion.
Bazil
Here is the Code:
1    use Win888a:dbb7:2d49:b3f6:8605:bf4e:caed:e5a4ODBC;
2    if (!($dbh = new Win888a:dbb7:2d49:b3f6:8605:bf4e:caed:e5a4ODBC("DSN=CameraSQL;UID=***;PWD=***" )))
3   {
4     $Err   ='ODBC';
5     $ErrMsg='ODBC:'. "new(): " . Win888a:dbb7:2d49:b3f6:8605:bf4e:caed:e5a4O888a:dbb7:2d49:b3f6:8605:bf4e:caed:e5a4Error();
6     print $ErrMsg <BR>;
7     die;
8    }
9    $SqlString = " Select viewcontent  from NewProfile where  ID='Prof2' ";
10   if(($dbh->Sql( $SqlString )))
11  {
12    $ErrMsg = 'SQL-Err:'.$dbh->Error();
13    print "SQL ERR on: $SqlString $ErrMs
14   die
15  };
16   $dbh->FetchRow();
17   {
18   undef %Data;
19   %Data       = $dbh->DataHash();
10   $FldContent=$Data{$_[1]};"
    @Admin: "- There are no trouble fetching non blob fields, (Text ,numeric etc.)
-Inserted a 3 character text into Blob Field, OK
- Fetch a 3 Characte Blob text "ABC" failed as well
It looks like trying to allocate -1 byte to image field and it failes!!!
SQL ERR on: Select viewcontent  from NewProfile where  ID='AA' and
CUSTID='BEHZAD' SQL-Err:[911] [2] [0] "Could not allocate enough memory (-1
bytes) for column 1.
"
news:<email_address>
<quote>
have a
";
database?
with"
{'source': 'USENET', 'other_information': '{"reply_count": 1, "forum_name": "comp.lang.perl.misc.20140729.mbox"}', 'file': 'data/output/usenet-comp.lang.parquet'}