Board index » delphi » Storing BLOB > 32K

Alexey E. Matveev

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Storing BLOB > 32K

In my application i will store images to MS SQL image field. For connecting
to MS SQL Server 7.0sp2 i use:
BDE 5.11; BDE alias i have configured to use ODBC datasource. My ODBC
Administrator version is 3.510.4202 and SQL Server driver version is 3.70
(mdac 2.1sp2)
If i tryed to store image > 32Kb i have a BDE Error: Invalid BLOB length. I
know that to resolve this problem i must change the BLOB SIZE parameter in
BDE configuration, but this parameter does not appear...

I very need HELP!
P.S. I also tryed to connect to SQL Server version 6.5 and all working.

 
Gary Wilmo

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Storing BLOB > 32K


Alexey E. Matveev <postmas...@fund.ru> wrote in message
news:8jcu59$ibh3@bornews.borland.com...

Quote
> In my application i will store images to MS SQL image field. For
connecting
> to MS SQL Server 7.0sp2 i use:
> BDE 5.11; BDE alias i have configured to use ODBC datasource. My ODBC
> Administrator version is 3.510.4202 and SQL Server driver version is 3.70
> (mdac 2.1sp2)
> If i tryed to store image > 32Kb i have a BDE Error: Invalid BLOB length.
I
> know that to resolve this problem i must change the BLOB SIZE parameter in
> BDE configuration, but this parameter does not appear...

> I very need HELP!

> P.S. I also tryed to connect to SQL Server version 6.5 and all working.

Why not use the native MSSQL driver?
--
Gary Wilmot
C/S Project Manager
OneClickHR plc
http://www.oneclickhr.com
Ing. Sami Casab

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Storing BLOB > 32K


Use borland sql native driver for MSSQL instead ODBC. I am working with
images too and it works fine.

Chears.
--

Visita nuestra pgina en www.constructoradesoftware.com
Gary Wilmot <g...@SPAMTRAPvisualpersonnel.co.uk> escribi en el mensaje de
noticias 8jd2pe$i...@bornews.borland.com...

Quote
> Alexey E. Matveev <postmas...@fund.ru> wrote in message
> news:8jcu59$ibh3@bornews.borland.com...
> > In my application i will store images to MS SQL image field. For
> connecting
> > to MS SQL Server 7.0sp2 i use:
> > BDE 5.11; BDE alias i have configured to use ODBC datasource. My ODBC
> > Administrator version is 3.510.4202 and SQL Server driver version is
3.70
> > (mdac 2.1sp2)
> > If i tryed to store image > 32Kb i have a BDE Error: Invalid BLOB
length.
> I
> > know that to resolve this problem i must change the BLOB SIZE parameter
in
> > BDE configuration, but this parameter does not appear...

> > I very need HELP!

> > P.S. I also tryed to connect to SQL Server version 6.5 and all working.

> Why not use the native MSSQL driver?
> --
> Gary Wilmot
> C/S Project Manager
> OneClickHR plc
> http://www.oneclickhr.com

Other Threads

1. Store BLOB to SQL Server > 32K

2. ODBC invalid bitmap image error (BLOB > 32K)

3. Blobs > 32k Sybase SQL Anywhere

4. Storing >32k of info in a memo like manner

5. Displaying >32k Memo blob

6. BLOB > 32K and ADO

7. BLOB > 32K with ORACLE 8 i

8. BLOB > 32K with Sybase Database

9. BDE and BLOBS > 32K

10. SQL Anywhere retrieving BLOBS > 32k