BDE support of the Text data type in SQL Server 2000

Apostolos Dimopoulos

Delphi Developer

Fri, 20 May 2005 03:26:18 GMT

BDE support of the Text data type in SQL Server 2000

Hi,

I am using BDE (Delphi 6 Pro) to connect to an SQL Server 2000. With
text fields I have the following problem. They are inserted correctly in the
database, but when using a Select statement to retrieve them I only get the
first 32Kbytes of data even though the @@TEXTSIZE variable of SQL Server is
set to 2GB. Any ideas???

Thanks,
Apostolos

Bill Tod

Delphi Developer

Fri, 20 May 2005 04:18:43 GMT

Re:BDE support of the Text data type in SQL Server 2000

Set the BlobSize parameter of the driver to something larger than 32k
using BDE Administrator.

On Sun, 1 Dec 2002 21:26:18 +0200, "Apostolos Dimopoulos"

Quote

<adi...@dreamtech.gr> wrote:
>Hi,

> I am using BDE (Delphi 6 Pro) to connect to an SQL Server 2000. With
>text fields I have the following problem. They are inserted correctly in the
>database, but when using a Select statement to retrieve them I only get the
>first 32Kbytes of data even though the @@TEXTSIZE variable of SQL Server is
>set to 2GB. Any ideas???

>Thanks,
>Apostolos

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Apostolos Dimopoulo

Delphi Developer

Fri, 20 May 2005 15:51:50 GMT

Re:BDE support of the Text data type in SQL Server 2000

Thanks!!

Quote

"Bill Todd" <b...@notthis.dbginc.com> wrote in message

news:8krkuukuleo14vtpme7s47h2lsphcs6rck@4ax.com...

Quote

> Set the BlobSize parameter of the driver to something larger than 32k
> using BDE Administrator.

> On Sun, 1 Dec 2002 21:26:18 +0200, "Apostolos Dimopoulos"
> <adi...@dreamtech.gr> wrote:

> >Hi,

> > I am using BDE (Delphi 6 Pro) to connect to an SQL Server 2000. With
> >text fields I have the following problem. They are inserted correctly in
the
> >database, but when using a Select statement to retrieve them I only get
the
> >first 32Kbytes of data even though the @@TEXTSIZE variable of SQL Server
is
> >set to 2GB. Any ideas???

> >Thanks,
> >Apostolos

> --
> Bill (TeamB)
> (TeamB cannot respond to questions received via email)

Other Threads

1. SQL Server 2000 and BDE types

2. Exporting Image data type from SQL Server to Text File

3. SQL Server Text Data Type

4. MS SQL Server newbie - importing text to SQL tables from a text data feed

5. BDE and SQL Server uniqueidentifier data type

6. SQL 2000 data type problems

7. paradox binary type to sql server 2000 ...

8. Invalid Field Type for nchar and nvarchar data types (I am using SQL Server 7.0)

9. Retreive values from text columns (sql server 2000)

10. SQL Server 2000 isn't returning text fields