ODBC and JDBC Guide

Table Of Contents
Index
Numerics
32-bit
architecture 12
client driver (Windows) 13
ODBC administrator (Windows) 13
64-bit
architecture 12
client driver (Windows) 13
data types 30
ODBC administrator (Windows) 13
A
Access via ODBC/JDBC extended privilege 19
accounts and privileges 19
ARRAY data type 25
auto-generated keys 24
B
BLOB 30
Boolean data type 25
C
CAST function 30
catalog function 29
client application, using FileMaker as 5
CLOB data type 25
column names 20
configuring a FileMaker data source
for JDBC 27
for ODBC (OS X) 21
for ODBC (Windows) 20
container field
JDBC data type mapping 30
ODBC data type mapping 30
cursors in JDBC 24
D
data source
configuring for access for JDBC 27
configuring for access via ODBC (OS X) 21
configuring for access via ODBC (Windows) 20
disabling a shared FileMaker database file 7
one DSN for each FileMaker database file 8
verifying access via JDBC 28
verifying access via ODBC (OS X) 21
verifying access via ODBC (Windows) 20
data type mapping
JDBC client driver 30
ODBC client driver 29
DatabaseMetaData methods 29
DATALINK data type 25
DATE 30
disabling a shared FileMaker database file 7
documentation 5
DOUBLE 30
driver properties
JDBC client driver 27
ODBC client driver (OS X) 21
ODBC client driver (Windows) 20
drivers, compatible versions 8
DSNs
creating (OS X) 21
creating (Windows) 20
one per file 8
E
error message formats 31
Execute SQL script step 9
, 10
ExecuteSQL function 9
, 10
extended privileges 19
external SQL data sources
accessing 9
supported versions 11
F
fields
mapping to JDBC 30
mapping to ODBC 29
FileMaker ODBC client driver
OS X 15
Windows 13
FileMaker products 7
FileMaker Server documentation 5
files
organizing on one computer 7
setting up access to 19
G
GetAs function 30
getColumnPrivileges method 29
getColumns method 29
getMetaData method 29
getTables method 29
getTableTypes method 29
getTypeInfo method 29
getVersionColumns method 29
H
holdable cursors in JDBC 24