ODBC and JDBC Developer’s Guide
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Using ODBC to share FileMaker data
- Chapter 3 Using JDBC to share FileMaker data
- Chapter 4 Supported standards
- Appendix A Mapping FileMaker fields to ODBC data types
- Appendix B Mapping FileMaker fields to JDBC data types
- Appendix C ODBC and JDBC error messages
- Index
Chapter 1
|
Introduction 9
Limitations with third-party tools
Microsoft Query Wizard
1 In a FileMaker data source, you cannot access table or column names that use High ASCII or double-
byte characters. Instead, use Microsoft Query and manually enter the characters, enclosed in double
quotation marks.
Microsoft Access
1 In a FileMaker data source, you cannot access table or column names that use High ASCII or double-
byte characters.
1 You cannot link to a FileMaker data source; however, you can import the FileMaker data source.
Networking requirements
You need a TCP/IP network when using FileMaker Server 8 to host a FileMaker database file as a data
source over a network. FileMaker
Pro 8 supports local access (same computer) only.
Using FileMaker Pro as a client application
You can use FileMaker Pro as an ODBC client application, interacting with data sources on the same
computer or over a network.
Limitations with third-party tools
Microsoft SQL Server
1 When you export decimal, float, money, or numeric data to a FileMaker database file, the auto-enter field
option Calculated value is set in the database. The option truncates values to zero decimal places using the
calculation
Truncate(fieldname;0). If you deselect the option in the created database and then repeat the
export, the auto-enter field option remains deselected.
Updating files from previous versions
FileMaker Pro 8 can open files created in earlier versions of FileMaker. See the Converting FileMaker
Databases from Previous Versions
guide for information.
Note FileMaker Server 8 can host FileMaker Pro 8 and FileMaker Pro 7v3 databases files.
FileMaker
Server 8 cannot host or convert earlier versions of FileMaker Pro database files.
If you previously shared a FileMaker database file as a data source
If you used LDAC (Local Data Access Companion) or RDAC (Remote Data Access Companion) to share a
database file in previous versions, you’ll need to make two changes. First, you need to set up users to belong
to an account that has the extended privilege of
Access via ODBC/JDBC (as part of the account’s privilege
set). Then, you need to enable your FileMaker
Server or FileMaker Pro host for ODBC/JDBC sharing (in
FileMaker
Pro, choose Edit menu > Sharing > ODBC/JDBC and turn on sharing).