O'Reilly logo

FileMaker 9 Developer Reference: Functions, Scripts, Commands, and Grammars, with Extensive Custom Function Examples by Steve Lane, Scott Love, Bob Bowers

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 16. JDBC/ODBC and External SQL Connectivity

About SQL-Based Data Exchange

A FileMaker system can act as a data source for external access via Open Database Connectivity (ODBC) or Java Database Connectivity (JDBC). Likewise, using the new External SQL Source (ESS) feature in FileMaker 9, FileMaker solutions can gain direct access to data in certain SQL-based database systems. FileMaker continues to support the ability to import records from an ODBC data source, and to execute SQL statements against remote data sources using the Execute SQL script step.

This chapter discusses how to make a FileMaker database available for external access from ODBC or JDBC. It also covers how to set up a Data Source Name (DSN) on both the Mac OS and Windows, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required