SQL 2005 Native Client Truncates Blob fields

pharry · Post by **pharry** » Wed 02 Jul 2008 07:55

We have an application that is storing a report builder definition in a SQL text field. When we try to retrieve the definition using SQL 2005 native client using sqlncli 2005.90.3042.0000 only part of the data is returned. If we remove the SQL Native client and use OLE DB the all of the data in the text field is returned to the application. DBexpress version is 4.20.0000.0005.

Is there a way to make dbexpress use OLE DB rather than the native client?

I can retrieve all the data from the column if I use SQL Server Manager Studio, which doesn't seem to use the SQL native client.

Any suggestions.

Antaeus · Post by **Antaeus** » Wed 02 Jul 2008 11:44

pharry wrote:Is there a way to make dbexpress use OLE DB rather than the native client?

This possibility was added in DbxSda 4.25.7. You can setup which provider to use through the VendorLib property of TSQLConnection. For more information see the Readme.html file. You will find it in the DbxSda installation directory.