Devart Forums

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?

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 .

That fixed it thank you.