Querying Datefield from MSSQL LINKED From MySQL
Posted on 2008-10-23
I have MSSQL and MySQL Linked together. This is a temporary solution. What I can't do is pull the date field from MySQL into SQL Server.
SELECT * FROM openquery(LINK, 'SELECT entry_date,territory FROM thstew_orders.oetable_backup')
MySQL Data Type for DATE FIELD = DATE
Error Message I receive:
Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.
what can I do?