ODBC and JDBC Guide

Table Of Contents
4
Chapter 4
Using ODBC to share FileMaker data 19
About ODBC 19
Using the ODBC client driver 20
Overview of accessing a FileMaker database file 20
Accessing a FileMaker database file from a Windows application 21
Specifying ODBC client driver properties for a FileMaker DSN (Windows) 21
Changing an existing ODBC client driver (Windows) 21
Verifying access via ODBC (Windows) 23
Accessing a FileMaker database file from an OS X application 23
Specifying ODBC client driver properties for a FileMaker DSN (OS X) 23
Changing an existing ODBC client driver (OS X) 23
Verifying access via ODBC (OS X) 25
Chapter 5
Installing FileMaker JDBC client drivers 26
Software requirements 26
Networking requirements 26
JDBC client driver installation 26
Using the JDBC client driver 27
Chapter 6
Using JDBC to share FileMaker data 28
About JDBC 28
Using the JDBC client driver 28
About the JDBC client driver 28
Using a JDBC URL to connect to your database 29
Specifying driver properties in the URL subname 31
Solutions with multiple FileMaker database files 31
Verifying access via JDBC 32
Chapter 7
Reference Information 33
ODBC Catalog functions 33
JDBC Meta Data functions 33
Mapping FileMaker fields to ODBC data types 33
Mapping FileMaker fields to JDBC data types 34
Data types in 64-bit applications 34
ODBC and JDBC error messages 35
ODBC error messages 35
JDBC error messages 35
Index 36