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?
Question
What is the difference between Microsoft SQL Server Non-Spatial and Microsoft SQL Server Non-Spatial (JDBC) formats to connect with SQL Server?
+8- Contributor
- 15 replies
- 8391 replies
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