Cannot preview SQL server tables with TIMESTAMP fields in ArcGIS

Last Published: April 25, 2020


The tables are listed under the OLE DB connection object in the ArcMap TOC but the data cannot be previewed.


It is not possible to preview SQL Server tables which contain fields defined as TIMESTAMP. This is due to a data type conversion error when using either the Microsoft OLE DB provider for SQL Server or the Microsoft OLE DB provider for ODBC drivers (and an ODBC DSN) to make the connection to the database.

Solution or Workaround

Try one of these solutions:

  • If appropriate, re-define the fields in the database table as data type DATETIME instead of TIMESTAMP.
  • Define a view of the table excluding the fields defined as data type TIMESTAMP.

Article ID:000002626

  • ArcMap 8 x
  • ArcMap 9 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options