What's ODBC mode?
Open Data Base Connectivity is a standard for interchange of data between database systems.
( i.e. Oracle, MySQL, Filemaker Server, etc.)
I didnt ask what ODBC was. I asked what you mean by ODBC mode.
Using ODBC as the connection protocol between Filemaker Pro and Filemaker Server Advanced instead of native mode.
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.
Filemaker Pro supports ODBC connectivity and Filemaker Server Advanced serves ODBC data. Filemaker Support indicated it would work, they just had no benchmarks on which was faster. I am simply trying to find out if anyone has tested both modes.
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:MS SQL Server 2000 Oracle 10g MS SQL Server 2005 Oracle 11g* MS SQL Server 2008* MySQL 5.0 Community Edition (free) Oracle 9i My SQL 5.1 Community Edition* (free)
FileMaker its not one of them.