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?

  • September 19, 2022
  • 1 reply
  • 66 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
  • September 20, 2022

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings