cancel
Showing results for 
Search instead for 
Did you mean: 

In-Database datatype change

SOLVED
Kieran
Meteor

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.Alteryx.png

  • In Database
Alteryx
Alteryx

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:

OLEDB Driver.jpg

 

Using the Microsoft OLE DB Provider for SQL Server drivers:

OLE DB1.jpg

 

Instead use the SQL Server Native Client 11.0 driver:

SQL Native.jpgDateField.jpg

Christian Rincon
Customer Support Engineer
Alteryx
Kieran
Meteor

Thank you sir...