I using MS SQL 7.0 and all attributes of my table that i declare as varchar
greater than 255 only return a string of 248!!

I have BDE 5.01 an D5 with W2k. Is this problem with any configuration or what
??

thanks for any help.

Sr. Norldir Kunkel

You need to use a memo (text) field for strings longer than 255, not a
varchar field.
-Howard

Nope, you need to use something other than the BDE SQLINKs driver. This uses
the dblib API for SQL Server which was not updated in SQL 7/2000 to support
unicode or long strings. Try using ADO instead.

-Euan

But ADO have a poor access to my data base.
i try to insert 20,000 record's and update it, whit BDE it was done at 12min,
with ADO in 30min.

what's happen with this ?  is any configuration ?

thanks for help.

news:3bd5d855$1_1@dnews...

Euan,
  Even with ADO (which I use), you need to use a text field, as far as I
have seen at least.  There have been many posts talking about this problem
in the .ado newsgroup.
-Howard

news:3bd5d855$1_1@dnews...

Then I must be doing something wrong. Look in .attachements for the message
title:

MSSQL + ADO + StringFields Bigger than 255

Its a simple dataaware control app that connects to MS SQL, there is a
create script, you will need to change the connection string obviously. Hit
the connect button and then edit the string field which is already > 255
then make the update. All seems to work fine for me with the field defined
as a stringfield.

Delphi 5 + Update 1, SQL2k SP2 beta, MDAC 2.7 RTM

-Euan