Considerations before you begin working with ODBC data sources. A System DSN is available to all users who log in to your computer. Otherwise, tables from all schemas are listed. For information on supported drivers, see http: For example, if you will be accessing records from an Oracle database, you will configure an Oracle client driver.
|Date Added:||17 February 2005|
|File Size:||13.77 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
If your data source 55 in the list, the driver is already configured. Was this topic helpful? Otherwise, tables from all catalogs are listed. See Adding tables to the relationships graph. Click OK to save your data source information.
Was this topic helpful? Tip To identify whether a table in the relationships graph is a FileMaker table or from an ODBC data source, move the pointer over the arrow in the table header.
Accessing external ODBC data sources
The field names appear in italics. Each file path must appear on a separate line. Click Add to configure a driver for your data source. Additionally, data source configuration can vary from one ODBC driver manufacturer to another. A System DSN data source name is available to all users who log in to your computer.
Sharing FileMaker Pro data via ODBC or JDBC
You can change the name of the data source, specify a different DSN, set authentication options to log in to a named ODBC data source, or fileaker view options. The data source is now listed in the Manage External Data Sources dialog box. You can choose to view the names by alphabetical or custom order. See Defining conditional formatting for layout objects. FileMaker does not use SQL set semantics on queries.
Click Add to configure a driver for your data source. After you have configured the driver, you can access records in your data source. You cannot use variables or fields in these calculations.
Click OK to save odvc data source information. Long queries, attempts to scroll the entire ODBC table, or opening a large table can result in slower performance. Many drivers also offer options to customize how you access a data source, such as identifying a particular data source file. Determine which tables you want to access, and which data sources they are in. Binary large objects BLOBs such as pictures and sounds are not supported.
A User DSN is available only when you log odbd.
File paths are listed under Details. Note If you want to include other types, deselect all the Filter by Type options.
A User DSN is available only when you log in. You can change the field type of a timestamp shadow field to either date or time, but the data must be structured in a specific manner.
Need an ODBC for Filemaker 5
The external table appears in the relationships graph. For TypeFileMaker is selected by default. Additionally, data source configuration can vary from one ODBC driver manufacturer to another.
Then do one of the following:. For information on linking to and working with tables in the relationships graph, see Working with the relationships graph. See Editing value list privileges.