ODBC and JDBC Guide

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