Filemaker Server Advanced Native vs ODBC connect
Does anyone know whether Filemaker Client connections to Filemaker Server perform better in Native mode or ODBC mode.
Open Data Base Connectivity is a standard for interchange of data between database systems.
( i.e. Oracle, MySQL, Filemaker Server, etc.)
First, in most cases native tools are more efficient than other connections such as ODBC.
Second, I dont think what you are trying to do is even possible. ESS only works with certain Oracle, MySQL, and MS SQL server drivers. The SequelLink driver which allow FileMaker data to be shared is not one of them.
You should be able to import the data via ODBC but then it defeats the purpose.
You are missing the point completely. The term "support ODBC" is too general.
FileMaker whether its through FMSA or through its Pro versions can share its data via ODBC using the DataDirect 32-BIT SequeLink driver.
However getting ODBC data from external systems into FileMaker can be done in two ways.
1. Import via ODBC.
2. External Sequel Sources ( ESS ).
ESS allows FileMaker to connect "live" via ODBC into other databases. FM10 supports the following:
FileMaker its not one of them.
Retrieving data ...