Skip to main content
Question

What is the difference between Microsoft SQL Server Non-Spatial and Microsoft SQL Server Non-Spatial (JDBC) formats to connect with SQL Server?

  • Sep 19, 2022 8:11 AM UTC
  • 1 reply
  • 141 views

david_
Contributor
Forum|alt.badge.img+8

We have two formats to connect with SQL Server :

 

  • Microsoft SQL Server Non-Spatial
  • Microsoft SQL Server Non-Spatial (JDBC)

 

What is the difference between them?

 

1 reply

david_r
Celebrity
  • Sep 20, 2022 7:13 AM UTC

The format is exactly the same, it's just the connection method that differs. The non-JDBC connection uses Microsoft ADO to connect to the database, which I believe is only available on Windows.

See also https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/mssql_ado/mssql_ado.htm