Error 8114

Troubleshooting SQL Server

Troubleshooting

Error 8114

Severity Level 16
Message Text

Error converting data type %ls to %ls.

Explanation

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.

Action

Remove the remote table column of DBTYPE_DATE data type from the query select list or predicate list.

See Also

datetime and smalldatetime

Distributed Queries

Errors 7000 - 7999