• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1516
  • Last Modified:

driver for FileMaker data

I am trying to set up a data link between Excel and a FileMaker Pro database.  I am following these instructions from a MS website:

Create a File DSN Using Microsoft Excel
Using the Create New Data Source dialog box, you can create a DSN for your FileMaker Pro database. The DSN that is created this way will always be a File DSN.
1.      
2.      Start FileMaker Pro and open the database for which you want to create the data source.
3.      Start Microsoft Excel.
4.      On the Data menu, point to Get External Data and then click Create New Query.
5.      On the Databases tab, select <New Data Source> and then click OK.
6.      Type the name of your data source in the What name do you want to give your data source? box.
7.      In the Select a driver for the type of database you want to access list, select ODBC 3.11 FileMaker Pro PPC.
8.      Click Connect.
9.      If you want to specify a default table for your data source, select the table in the Select a default table for your data source (optional) list.
10.      Click OK.


When I get to step 7, the ODBC 3.11 driver is not listed; how do I access or download that?

Anything else I should know?
0
pjfromny
Asked:
pjfromny
  • 5
  • 3
1 Solution
 
jameso99Commented:
I believe you can find the ODBC driver for FileMaker Pro on the installation media for FMP, either on the CD or download.
It's packaged deep in an ODBC folder- you'll have to dig for it unfortunately.  I have gotten it to work before to SQL server so an Excel connection would probably be very similar.  I'll see if I can find my original connection string for you.

Find that driver and install it (there might even be a ReadMe on that installation media for FMP) and test the ODBC connection, then you can move on to Excel.
0
 
jameso99Commented:
0
 
pjfromnyAuthor Commented:
I've installed the ODBC driver for FileMaker.  I have the FM file open and am using Excel.  I choose "get data from Microsoft Query," new data source, enter a name, select the FileMaker ODBC driver, click on connect, which opens the FM DSN Configuration dialog.

I choose localhost (a local file), and connect to host for available databases.

My database is listed in the databases window, and I choose next.

I choose test, it asks for Filemaker Login, enter the ID (no password), and it returns test completed successfully. I choose ok.

I return to the DSN Configuration screen, and choose done.  It opens the Filemaker Login again, I enter the same ID, and there is a Microsoft Query dialog box which says "unable to open file, error 802.  The help option does not have any info on error 802.

Any ideas?

0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
jameso99Commented:
Try closing the FMP file before attempting to have another application access it.

You may need to create an account with a password and use this to login, or you might need to set up the database for Sharing or actually allow ODBC connections, something that is done in the database file's Administration property window.
Go to "Sharing -> ODBC/JDBC" and make sure ODBC/JDBC is turned on.  Then make sure the Access privileges is set to All Users
0
 
pjfromnyAuthor Commented:
If the FMP file is closed, the connection fails at the test stage.  I have checked to make sure ODBC sharing is enabled.  I added a password.

Same result - the test completes successfully, then next screen says filemaker logon, it returns error 802.
0
 
jameso99Commented:
What version of FileMaker Pro and Excel are you running?
Are you using Web Publishing?  Are you running Windows 7/Vista/XP?
0
 
jameso99Commented:
ODBC 3.11 is a way old driver - and "FileMaker Pro PPC" is waaaaay old.

In that guide I linked to (there are different versions of that document for the versions of FMP) it tells how to create system DSNs, etc.  Have you tried that yet for your version/operating system?

You might need to use the DataDirect 32-BIT SequeLink 5.5 driver as well.  The guide can help.

http://www.filemaker.com/downloads/pdf/fm7_odbc_jdbc_install.pdf
http://www.filemaker.com/downloads/documentation/fm8_odbc_jdbc_install.pdf
http://www.filemaker.com/downloads/pdf/fm9_odbc_jdbc_guide_en.pdf
http://www.filemaker.com/downloads/pdf/fm10_odbc_jdbc_guide_en.pdf
http://www.filemaker.com/support/product/docs/fms/fm11_odbc_jdbc_guide_en.pdf

0
 
pjfromnyAuthor Commented:
Win Vista; FMP 11; Set up the connection via administrative services, and it seems to have worked.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now