On Windows, youll need to connect to the server using the SAT, right-click the server and choose Properties, and then choose the Clients tab and click the Server Advanced Settings button, as shown in Figures First, though, well look at how to configure individual databases to permit xDBC access by either means. I have FMP13 advanced and using the version Tech support scams are an industry-wide issue where scammers attempt to trick you into paying for unnecessary technical support services. Was this topic helpful?

Uploader: Dum
Date Added: 11 April 2013
File Size: 47.91 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 95490
Price: Free* [*Free Regsitration Required]

Is there any chance to get a working filemaker connection in the near future?

This functionality relies on the presence of Microsoft Query. Prp Query Wizard allows you to choose from a list of “tables” on the left of the dialog. Make sure that the appropriate extended privileges are enabled in each file, and assigned to the correct users.

Filemaker ODBC – Microsoft Community

This is the standard port for accessing FileMaker via xDBC, both on the client and oebc the server, and it cannot be changed. Like other means of external access, such as access via FileMaker Mobile, or access via XML, access via xDBC requires that filemaket specific extended privilege be enabled in each file to be accessed. If no driver appears for the data source you want to use, you can use a driver from a third-party vendor.


Additionally, data source configuration can vary from one ODBC driver manufacturer to another. This means that you need one DSN for each file you want to access via xDBC, unless the files are joined via relationships. Its a good idea to test your connection to the data source after you e done configuring the DSN.

Tell us about your experience with our site.

Well refer to the two technologies together as xDBC from time to time for convenience. Click Add, and then pick the FileMaker driver you just configured.

For example, if you will be accessing records filemaler an Oracle database, you will configure an Oracle client filenaker. For Nameenter descriptive text to identify the data source. As a result, you have a bit more work to do. If you don see that driver as an available choice when configuring, it may mean that the driver has not been installed, or that there was a problem with the installation. To access FileMaker data from Excel, open a new Excel workbook.

Tech support scams are an industry-wide issue where scammers attempt to trick you filfmaker paying for unnecessary technical support services. Its possible to get a bit lost in the abundance of drivers and configuration options.

Configuring an ODBC client driver

Other ODBC-capable applications on the same computer will then be able to access data in your files. Many drivers also offer options to customize how you access a data source, such as identifying a particular data source file.


A User DSN is available only when you log in. Microsoft Excel is an easy example, especially because it has a full-featured toolset for external data access.

If the connection is not functioning correctly, no list of files will appear. When you e done configuring the DSN, it will be available for use. I have the same question 1. In the configuration dialog box, click Continue. Scott LoveSteve Lane. Youll need to do a little extra driver configuration on the Mac OS. OpenLink makes a somewhat more full-featured replacement for the Apple utility. filmaker

Accessing FileMaker Data Using ODBC and JDBC

Unlike on Odbv, simply installing the driver won automatically make it available for use. The lower half of the dialog simply represents an alternative way to enable the fmxdbc extended privilege in each of the open files. As with other external access methods, it may make sense to create a special user oxbc xDBC access, and limit xDBC to that user alone.

Click the Add button to create a new DSN. Astelix2 Created on October 22, Even if the data source is correctly broadcasting the availability of files, youll also want to test access to the specific chosen file.