ODBC and JDBC Guide

Table Of Contents
34
H
holdable cursors in JDBC 25
I
Import Records script step 9, 10
importing ODBC data 9
installation requirements 12
, 23
J
Java Development Kit (JDK) 26
Java version 23
JDBC
client driver, described 25
described 25
error messages 32
JDBC client driver
driver class and main entry point 26
mapping data types 31
registering with the JDBC driver manager 26
specifying the JDBC URL 26
verifying access 29
JDBC SPI 26
M
mapping data types
JDBC client driver 31
ODBC client driver 30
metadata methods 30
Microsoft Access 8
MySQL 11
N
networking requirements 8
null value 30
O
ODBC
described 19
error messages 32
repeating fields 31
ODBC Administrator (OS X) 22
ODBC catalog functions 30
ODBC client driver
mapping data types 30
verifying access (OS X) 22
verifying access (Windows) 21
ODBC Data Source Administrator
creating a DSN 14
opening 13
verifying ODBC access 21
ODBC Manager
creating a DSN 16
downloading 16
verifying ODBC access 22
online documentation 5
Oracle 11
OS X
creating a DSN 16
JDBC client driver requirements 23
verifying ODBC access 22
P
password
with JDBC 28
with ODBC 21
, 22
PDF documentation 5
port 2399
required for JDBC 24
required for ODBC (OS X) 16
required for ODBC (Windows) 13
privileges, extended 20
R
Rapid Application Development (RAD) tools 25
REF data type 26
registering the JDBC client driver 26
relationships graph 6
remote access 7
repeating fields 31
required ports
for JDBC 24
for ODBC (OS X) 16
for ODBC (Windows) 13
requirements for installation 12
, 23
runtime solutions, limitations 10
S
savepoint support 25
schema modification 6
setting up privileges and sharing 20
sharing, setting up ODBC/JDBC 20
SQL Query builder 6
, 10
SQL Server 11
SQL_DATE 30
SQL_DOUBLE 30
SQL_LONGVARBINARY 31
SQL_TIME 30
SQL_TIMESTAMP 30
SQL_VARCHAR 30
SQLColumnPrivileges 30
SQLColumns 30
SQLDescribeCol 30
SQLExceptions 32
SQLGetTypeInfo 30
SQLTables 30
system requirements
for JDBC client drivers 23
for ODBC client drivers 12