ODBC for FMP 5.5 s

[Pat Murray]

I am trying to create an ODBC connection to FM pro 5.5 file to migrate data to Access. I follow the necessary instructions by configuring the ODBC control panel and configuring the FM pro file for sharing.

In the ODBC data source administrator, system DSN tab, I select the Filemaker Pro ODBC driver. In the general tab I specify the FMP filename in data source name but when I try to use this in another application, it gives me an ODBC call failed error.

I’ve tried specifying the path of the file in the data source name but it doesn’t allow me.

I’ve also tried using File DSN and User DSN with but get the same errors with both

What am I doing wrong?

When specifying the file in data source name how does FM ODBC know where to pick up this File?

Cheers in advance.

Pat