Delphi 6, ADO, MS database "Date" field is same as ftWideString

Question

I want to copy elements to a remote MS-SQL database. I got conversion error on it.

When I checked the ADOTable structure I saw the MS field

WHENCREATED DATE [NULL]

is converted to

ftWideString 10

Hmmmmm....

Is it normal? Or I can set something to Date fields are come as TDateTime?

The Provider is "SQLOLEDB.1"

Answer 1

Its a DATE (yyyy-mm-dd) type which was introduced in SQL Server 2008 as an alternative to the DATETIME type.

Because SQLOLEDB.1 precedes this there is a backward conversion to DBTYPE_WSTR, using an updated provider (SQLNCLI) would be preferable.