PROBLEM
Feature Classes stored in SQL Server 2008 using the Geometry or Geography spatial type will not preview from ArcCatalog or ArcMap. The following error is returned:
"The selected object failed to draw:
Database:DBO.Feature Class: Underlying DBMS error [Microsoft OLE DB Provider for SQL Server: Deferred prepare could not be completed.][Database:DBO.Feature Class]"
Using the SQL Server Profiler to trace the failed operation returns an additional error:
"Error 206, Operand type clash: image is incompatible with geometry."
If trying to Load Data into this Spatial type or the data is not visible when published in a Map Service, other errors may occur that are related to underlying DBMS Errors.
Note:
This behavior may not occur across all client machines, as Microsoft has also provided the OLE DB and ODBC drivers through various Windows Updates depending on the operating system (OS).
To leverage the new functionality in Microsoft SQL Server 2008, the client computer making the connection to the database needs the Microsoft SQL Server 2008 Native Client installed. The native client contains necessary OLE DB and ODBC drivers required to query the spatial type.
For more information about this issue, please refer to the following Microsoft Developer Network topic: When to Use SQL Server 2008 Native Client.
Get help from ArcGIS experts
Download the Esri Support App