Below error message can appear while using the DateTimeOffset data type column in the information link with SQL Server.

======================================
Error message: Could not open information link.

TargetInvocationException at Spotfire.Dxp.Framework:
Exception has been thrown by the target of an invocation. (HRESULT: 80131604)

Stack Trace:
   at Spotfire.Dxp.Framework.ApplicationModel.ProgressService.ExecuteWithProgressCancelable(String title, String description, ProgressOperation operation, Boolean showCancelButton)
   at Spotfire.Dxp.Forms.Data.InformationDesigner.DesignerFormController.ExecuteInformationLink(CachedInformationLinkElement informationLink)

ImportException at Spotfire.Dxp.Data:
Failed to execute data source query. (HRESULT: 80131500)

Stack Trace:
   at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()
   at Spotfire.Dxp.Data.DataFlow.Execute()
   at Spotfire.Dxp.Data.DataFlow.DataFlowConnection.ExecuteQueryCore2()
   at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()
  
....(Full Error message attached)
InformationModelException at Spotfire.Dxp.Data:
Failed to execute query: Unsupported JDBC data type in query result: datetimeoffset (HRESULT: 80131500)
======================================

Root Cause: DateTimeOffset data type column is not supported in Spotfire while making use of SQL Server JDBC thin driver.