In-Database datatype change

[Kieran]

Hello,

I've run into an issue where the in-database tools are converting my "date" datatype fields to V_WStrings.

Attached is a screen shot example.

[ChristianR · Accepted solution]

Hi @Kieran

From previous experiences this is normally an issue caused when using the Microsoft OLE DB Provider for SQL Server drivers.

Instead use the SQL Server Native Client 11.0 driver:

Using the Microsoft OLE DB Provider for SQL Server drivers:

Instead use the SQL Server Native Client 11.0 driver:

[Kieran]

Thank you sir...