Click Add, and then pick the FileMaker driver you just configured. Its recommended that you read that chapter if you need a bit of background on those topics. The lower half of the dialog simply represents an alternative way to enable the fmxdbc extended privilege in each of the open files. The host and port should be localhost and , respectively; the ServerDataSource is the name of the database you want to access, minus any file extensions. This functionality relies on the presence of Microsoft Query. Like other means of external access, such as access via FileMaker Mobile, or access via XML, access via xDBC requires that a specific extended privilege be enabled in each file to be accessed. In the first place, its necessary to configure the data source to accept xDBC connections.
|Date Added:||4 October 2004|
|File Size:||59.32 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
If no driver appears for the data source you want to use, you can use a driver from a third-party vendor. Its installed by default under certain circumstances, but you may need to install it separately if its missing.
Its a good idea to test your filwmaker to the data source after you e done configuring the DSN. The lower half of the dialog simply represents an alternative way to enable the fmxdbc extended privilege in each of the open files.
What is an ODBC driver?
If this query is one you foresee reusing, it would be wise to save it for later use via the Save Query button, also shown in Figure This site in other languages x. To access FileMaker data from Excel, open a new Excel workbook. Soliant Development Standards show all menu. I have the same question 1. Was this topic helpful? Thanks for your feedback, it helps us improve the site.
For Nameenter descriptive text to identify the data source.
Mac ODBC: FileMaker Pro connectivity options by Actual Technologies
So far, the techniques detailed in this chapter have involved pushing data out of FileMaker into static export files. Youll need to explicitly install these drivers from the FileMaker install mediathey are not installed by default when you install Pdbc Pro or FileMaker Pro Advanced.
Presumably youve also already installed the FileMaker ODBC driver, according to the instructions that came with the installer files on the FileMaker disk.
OpenLink makes a somewhat more full-featured replacement for the Apple utility. Scott LoveSteve Lane. You can help protect yourself from scammers by verifying that the contact is a Microsoft Agent or Microsoft Employee and that the phone number is an official Microsoft global customer service number. How satisfied are you with this reply? This is the standard port for accessing FileMaker via xDBC, both on the client and on the server, and it cannot be changed.
Click Add to configure a driver for your data source.
Configuring an ODBC client driver
Finally, you need to make a selection in the Server Data Source field. After the FileMaker files are hosted and configured obc, its necessary to configure client application access.
This issue appears to be solved with the latest version v If the connection is not functioning correctly, no list of files will appear.
Clicking the button to the right of the Server Data Source field will allow you to choose a file to access, as shown in Figure The Data Source Name field is for your own information; name it anything you like its best to avoid spaces. Click Add, and then pick the FileMaker driver you just configured.
Make sure that the appropriate extended privileges are enabled in each file, and assigned to the correct users. As with other external access methods, it pri make sense to create a special user for xDBC access, and limit xDBC to that user alone.
oodbc In the configuration dialog box, click Continue. A User DSN is available only when you log in. Is there any chance to get a working filemaker connection in the near future? This functionality relies on the presence of Microsoft Query.
First, youll need to have an ODBC administration tool installed.