DBX report SQL Server Date fields as ftWideString

sboydlns · Post by **sboydlns** » Fri 19 Aug 2011 20:02

I am using dbExpress with Delphi 2007 and the DevArt MS SQL DBX driver. When I open a query which includes a column of type 'Date' from a SQL SErver 2008 database, the TField for that column reports its DataType as ftWideString rather than ftDate.

I really need to be able to identify date columns. How can I accomplish this?

AndreyZ · Post by **AndreyZ** » Mon 22 Aug 2011 10:30

Hello,

To solve the problem, you should use native client provider. For this, you should set the VendorLib property of the TSQLConnection component to sqlincli.dll .

sboydlns · Post by **sboydlns** » Mon 22 Aug 2011 17:57

That fixed it thank you.