IMAGES (MS SQL Server 2000 with PB 8)

[password99]

I am using MS SQL Server 2000 with PB 8

I am using SELECTBLOB to retrieve images from the Database, however only
32KB
(32767 bytes) of the image gets retrieved. The images stored in the DB
are
greater than 32KB.

In help it mentioned to set AutoCommit to True before calling SELECTBLOB
and I
tried that but it does not work. I even changed the DB setting on
application
startup to autocommit = true but it did not help.

Any thoughts are welcome.

 

[a4f7]

Hi,

I am trying to connect to Microsoft Sql server 2000 through Pb6.5 build 444. Sql server is on server and PB6.5 on client side. I am able to make connetions and also i am able to create new tables through databse object but when I try to open any tables it prompts me with message : SQLSTATE=S1003
[Microsoft][ODBC Driver Manager]Program type out of range. I will appreciate if anyone can help me out on this and thanks is advance.