

The data source is still available to link to other FileMaker databases.A data source, sharing your database files with other applications on the same computer using ODBC (Open Database Connectivity) and JDBC (Java Database Connectivity).

This only deletes the data source link to the current FileMaker Pro file. In the Manage External Data Sources dialog box, select the data source in the list. See Adding and selecting table occurrences. In the Specify Table dialog box, for Data Source, choose Add ODBC Data Source. Note Alternatively, you can choose the Relationships tab in the Manage Database dialog box and click. The data source is now listed in the Manage External Data Sources dialog box. In the Select ODBC Data Source dialog box, select the System DSN that you want to work with from this FileMaker Pro file. Names cannot be over 100 characters long. With the FileMaker database open, choose File menu > Manage > External Data Sources.
#FILEMAKER PRO OPEN SOURCE DRIVER#
Important Before creating a SQL data source, you must connect to the external data source via an ODBC driver and set up DSNs. See Working with a Claris Studio data source (Claris Pro only). Then select the table name from the list of tables. If a Claris Studio data source isn't present, choose Add Claris Studio Data Source (this option is available only to team managers in the current team). In the Specify Table dialog box, for Data Source, choose Claris Studio Data Source.

With the Claris Pro database open, choose File menu > Manage > Database.Ĭlick the Relationships tab, then click. To add a table from a Claris Studio data source (Claris Pro only): In the Specify Table dialog box, for Data Source, choose Add FileMaker Data Source.

Type indicates whether the data source is a FileMaker or ODBC data source. You can choose to view the names by alphabetical or custom order. Named data sources appear in creation order in the Manage External Data Sources dialog box. Each file path must appear on a separate line. You can also enter file paths by typing them directly into the file path list. Use multiple file paths when you want FileMaker Pro to search a list of potential files. Select a FileMaker Pro file to add to the path list.Ĭlick Open to add the path for this file to the file path list.Įach named FileMaker data source can consist of one or more file paths. This is the name that appears in the login and other dialog boxes. For Type, FileMaker is selected by default. With the database open, choose File menu > Manage > External Data Sources. Once you have defined data sources, data from the FileMaker, Claris Studio (Claris Pro only), or ODBC tables can be used in many of the same places as data in a local file (for example, on layouts and in scripts).įollow the steps below for the type of data source you want to add. ODBC data sources (links to external ODBC files) Your team's Claris Studio data source (Claris Pro only) Data sources provide access to data from other FileMaker Pro files and ODBC databases.
