• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 17. Exchanging Data via ODBC > Using FileMaker Data within an ODBC Appl...

Using FileMaker Data within an ODBC Application

Once you've turned on the Data Access Companions (explained on the previous page), your FileMaker data can be used by any ODBC-compliant application. The exact steps for tapping the FileMaker file will vary depending on which ODBC application you're using. The FileMaker ODBC driver must be installed on the computer that contains the ODBC client application. (See your network administrator for help on this.) Once the ODBC control panel has been installed, you'll need to configure the control panel by naming and locating the FileMaker file you'll be using from within the ODBC application. From there, it's just a matter of building queries for the FileMaker data using Structured Query Language (SQL) within your ODBC application.

To use FileMaker data from an ODBC application:

1.
You'll need to configure the ODBC by:

Choosing Start > Settings > Control Panel. In pre-Windows 2000 machines, double-click ODBC Data Sources (32bit) when the Control Panel window opens. On machines running Windows 2000 and Windows XP, you'll need to go one level deeper by also opening the Administrative Tools folder and choosing Data Sources (ODBC).

Choosing System Folder > Control Panels > ODBC Setup PPC if you're using a pre-OS X Mac. (OS X does not yet support ODBC import).

2.
When the ODBC Data Source Administrator dialog box appears, make sure the User DSN tab is active, and click Add (Figure 17.5).

Figure 17.5. To create a new ODBC data source, make sure the User DSN tab is active, and click Add.


3.
When the Create New Data Source dialog box appears, select the FileMaker Pro driver (Windows) (Figure 17.6) or the ODBC 3.11 FileMaker Pro PPC driver (Mac) (Figure 17.7), and click Finish.

Figure 17.6. When the Create New Data Source dialog box appears, select the FileMaker Pro driver, and click Finish.


Figure 17.7. When the Create New Data Source dialog box appears, select the ODBC 3.11 FileMaker Pro PPC driver, and click Finish.


4.
Make sure the General tab is activated when the driver setup dialog box appears (Figure 17.8), type a distinctive name into the Data Source Name text box and a Description if it will help users recognize the file.

Figure 17.8. Make sure the General tab is activated when the driver setup dialog box appears. If the database is not on your local network, check Use Remote Connection and enter an IP number in Server Address (top).


5.
If you'll be using a local file, click OK and you're done. If you'll be using a remote file not on the local server, check Use Remote Connection, enter the IP number in the Server Address text box, and then click OK.

6.
When the ODBC Data Source Administrator dialog box reappears, the newly named FileMaker data source will appear in the User Data Sources list (Figure 17.9). Click OK to close the dialog box. You're now ready to build your SQL query within your ODBC application and execute the query of the FileMaker file.

Figure 17.9. Once added, the newly named FileMaker data source appears in the User Data Sources list.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint