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

Chapter 11. FileMaker and Other Programs > Sharing Databases Using ODBC

Sharing Databases Using ODBC

Not only can you import ODBC data into your FileMaker database, you can share your FileMaker databases with ODBC client applications. To make it possible for others using ODBC to access your files, you must first register the FileMaker database on your computer as a data source, then turn on the Data Access plug-ins. The registration process is a bit different on Windows and Macs.

To register a database in Windows:

1.
Open the FileMaker database you want to register.

2.
From the Windows taskbar, choose Start > Settings > Control Panel. Double-click ODBC Data Sources.

The ODBC Data Source Administrator dialog box appears with the User DSN tab selected. You should see FileMaker listed as a user data source. If it isn't listed, click Add and follow the instructions that appear.

3.
Click the System DSN tab, then click the Add button.

4.
In the Create New Data Source dialog box, click the FileMaker Pro driver. Click Finish (Figure 11.62).

Figure 11.62. Specify the FileMaker ODBC driver to make your file available to other ODBC programs.


5.
In the ODBC FileMaker Pro Driver Setup dialog box, type the name of your database in the Data Source Name box. You can add a description if you'd like, but it's not required (Figure 11.63). Click Apply, and then OK.

Figure 11.63. Other programs will identify your database by the name you enter.


6.
Your database will now be listed in the System Data Sources window and will be available to other ODBC applications (Figure 11.64). Click OK to finish.

Figure 11.64. Your database will be available to other ODBC applications when it's listed as a data source.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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