Configuring an ODBC client driverWhether you are importing ODBC data or working with ODBC tables in the relationships graph, as a client application, you must configure a driver for the ODBC data source you’re using. For example, if you will be accessing records from an Oracle database, you will configure an Oracle client driver.
• For an overview of the various ways of working with ODBC data sources, see Using ODBC and JDBC with FileMaker Pro.
• 32-bit Windows: In the Windows Control Panel, choose Administrative Tools > Data Sources (ODBC). Administrative Tools appear in the System and Security category.
2. If your data source appears in the list, the driver is already configured. You can skip the remaining steps and begin accessing ODBC data, or choose your data source and click Configure to modify how you’ll interact with the data source.A System DSN (data source name) is available to all users who log in to your computer. A User DSN is available only when you log in.Important Only System DSNs are supported when you are working with ODBC tables in the relationships graph.
3. Click Add to configure a driver for your data source.
5. For Name, enter descriptive text to identify the data source.
6. Click Finish.
7. Click OK to save your data source information.
3. Click the System DSN tab (or, for ODBC imports, click either the System DSN tab or the User DSN tab).Important Only System DSNs are supported when you are working with ODBC tables in the relationships graph.If your data source appears in the list, the driver is already configured. You can skip the remaining steps and begin accessing ODBC data, or choose your data source and click Configure to modify how you’ll interact with the data source.A System DSN (data source name) is available to all users who log in to your computer. A User DSN is available only when you log in.
4. Click Add to configure a driver for your data source.
6. In the configuration dialog box, click Continue.
7. For Name, enter descriptive text to identify the data source.
8. Click Finish.
9. Click Done to save your data source information.