Error converting data type %ls to %ls.
If the error text refers to both DBTYPE_DATE and datetime, respectively, this error message indicates that a DBTYPE_DATE OLE DB data type column from a remote table could not be converted to a datetime value in Microsoft® SQL Server™. The DBTYPE_DATE column most likely has a value outside the range supported by the datetime data type (datetime values must be from January 1, 1753, through December 31, 9999). Because the range of values of the DBTYPE_DATE data type is larger than that of the SQL Server datetime data type, such errors can occur if the column contains values outside of the range supported by SQL Server.
Remove the remote table column of DBTYPE_DATE data type from the query select list or predicate list.
| Distributed Queries | Errors 7000 - 7999 |
| datetime and smalldatetime |