Use the following procedure as a general guideline for configuring data sources refer to the documentation that accompanies each data source application for details. Unless you have specific reasons for limiting driver use to just one user, its simpler to install it as a system driver, available to all users. As a result, you have a bit more work to do. Many drivers also offer options to customize how you access a data source, such as identifying a particular data source file. The new DSN will need several settings configured. Other ODBC-capable applications on the same computer will then be able to access data in your files. I have the same question 1.
|Date Added:||8 March 2017|
|File Size:||59.63 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
You can likewise enter anything you like for the description. Unless you have specific reasons for limiting driver use to just one user, its simpler to install it as a system filemaksr, available to all users. If your data source appears in the list, the driver is already configured.
Configuring an ODBC client driver
The lower half of the dialog simply represents an alternative way to enable the fmxdbc extended privilege in each of the open files. The Choose Data Source dialog, shown in Figure After the FileMaker files are hosted and configured correctly, its necessary to configure client application access.
Other ODBC-capable applications on the same computer will then be able to access data in your files. How satisfied are you with this response?
Accessing FileMaker Data Using ODBC and JDBC
Click Done to save your data source information. This choice, and the specific paths it entails, are discussed in the driver install instructions. When you e done configuring the DSN, it will be available for use.
To do so, click the Test Connect button shown previously in Figure Was this topic helpful? Then do one of the following:. First, youll need to have an ODBC administration tool installed.
The utility is free; examine the OpenLink web site www. Click here to find out more. In the first place, its necessary por configure the data source to accept xDBC connections. Click Add, and then pick the FileMaker driver you just configured. If this extended privilege is not enabled, xDBC access to the file will not be possible, regardless of any other configuration that has been performed.
Configuring an ODBC client driver
Since Excel “upgraded” to After you have configured the driver, you can access records in your data source. If there are no problems with configuration or passwords, you should see a message stating that the test was successful.
Youll be able to give the driver a descriptive name of your own choosing. Note that if you know the files name, you can simply type it into the box, minus any. Quantitative Methods in Project Management. Rather than having specific slots already set aside, its necessary instead for you to specify the names of the configuration parameters yourself.
There are two differences between these methods:. Filfmaker youve also already installed the FileMaker ODBC driver, according to the instructions that came with the installer files on the FileMaker disk. Scott LoveSteve Lane. Thanks for your filemaket, it helps us improve the site.
Specify hostportand ServerDataSource as keywords, and also specify the appropriate values. Youll need to do a little extra driver configuration on the Mac OS. Finally, youll have the option of specifying what to do with the selected data, as shown in Figure Microsoft Excel is an easy example, especially because it has a full-featured toolset for external data access.