ODBC and JDBC Guide
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Accessing external SQL data sources
- Chapter 3 Installing FileMaker ODBC client drivers
- Chapter 4 Using ODBC to share FileMaker data
- Chapter 5 Installing FileMaker JDBC client drivers
- Chapter 6 Using JDBC to share FileMaker data
- Chapter 7 Reference Information
- Index
Index
A
Access via ODBC/JDBC extended privilege 20
accounts and privileges 20
ARRAY data type 29
auto-generated keys 28
B
Boolean data type 29
C
CAST function 34
client application, using FileMaker as 5
CLOB data type 29
column names 21
configuring a FileMaker data source
via JDBC 31
via ODBC (OS X) 23
via ODBC (Windows) 21
container field
JDBC data type mapping 34
ODBC data type mapping 34
cursors
in JDBC 28
D
data source
configuring for access via JDBC 31
configuring for access via ODBC (OS X) 23
configuring for access via ODBC (Windows) 21
disabling a shared FileMaker database file 7
one DSN for each FileMaker database file 8
verifying access via JDBC 32
verifying access via ODBC (OS X) 25
verifying access via ODBC (Windows) 23
data source names. See DSNs
data type mapping
JDBC client driver 34
ODBC client driver 33
database, DSN 22
DATALINK data type 29
disabling a shared FileMaker database file 7
driver properties
JDBC client driver 31
ODBC client driver (OS X) 23
ODBC client driver (Windows) 21
drivers
uninstalling old 8
DSNs
creating (OS X) 23
creating (Windows) 21
one per file 8
E
error message formats 35
Execute SQL script step 10
ExecuteSQL function 10
extended privileges 20
F
fields
mapping to JDBC 34
mapping to ODBC 33
FileMaker products 7
files
organizing on one computer 7
setting up access to 20
G
GetAs function 34
H
holdable cursor 28
host, DSN 22
, 24
I
Import Records script step 10
installation requirements 12
, 26
J
Java Development Kit (JDK) 29
Java version 26
JDBC
client driver, described 28
described 28
error messages 35
JDBC client driver
driver class and main entry point 29
mapping data types 34
registering with the JDBC driver manager 29
specifying the JDBC URL 29
verifying access 32
JDBC Meta Data functions 33
JDBC SPI 29
M
mapping data types
JDBC client driver 34
ODBC client driver 33