Thread: BUG #2151: ODBC, Large Object, Visual Basic, GetChunk

BUG #2151: ODBC, Large Object, Visual Basic, GetChunk

From
"Kerim Simsek"
Date:
The following bug has been logged online:

Bug reference:      2151
Logged by:          Kerim Simsek
Email address:      kerim@panix.com
PostgreSQL version: 8.1 Windows
Operating system:   Windows 2000 Pro
Description:        ODBC, Large Object, Visual Basic, GetChunk
Details:

Large object Table:

  CREATE TABLE tbl_documents
  (
     iddocument int4 NOT NULL,
     documentsize int4 NOT NULL DEFAULT 0,
     document lo
  )

Visual Basic Code:

  flen = rs!documentsize
  chunk() = rs!Document.GetChunk(flen)

Returns Error:

  Error Number: 3219
  Description: Operation is not allowed in this context.

----------
NOTES:
  Client OS: Windows 2000
  Postrgresql Server: 8.1 on Windows
  Interface: Visual Basic 6.0
  ODBC: 8.01.01.02 (ANSI)
NO ERRORS ON THE PRODUCTION VERSION:
  Client OS: Windows 2000
  Postrgresql Server: 7.3.4 on Fedora Core
  Interface: Visual Basic 6.0
  ODBC: 8.01.01.02 (ANSI)