SOLVED
In-Database datatype change
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Kieran
7 - Meteor
‎04-21-2017
01:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- In Database
2 REPLIES 2
ChristianR
Alteryx Alumni (Retired)
‎04-24-2017
07:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
Christian Rincon
Manager, Customer Support
Alteryx, Inc.
Manager, Customer Support
Alteryx, Inc.
‎04-26-2017
02:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you sir...