PureBasic Forums - English

Hello PB experts,

I am trying to construct an interface for FileMaker Pro 6. I understand this can be done through ODBC or ActiveX or perhaps DDE. I've been playing with the ODBC functions of PB but can only get a connection established. No queries work.

Anyone able to help in this?

Thanks

I don't think Filemakers ODBC driver works without Filemaker Pro actually being installed on your computer.

It uses something FileMaker calls 'companions' (local data access companion for local tables and remote data access companion for networked tables) which are installed with FileMaker Pro to communicate with the tables.

"The Data Access Companions are Filemaker Pro plug-ins that interface between the FileMaker Pro ODBC driver and your FileMaker Pro database." - from the FileMaker manual

Another possibility is FileMakers use of SQL , if you use the
'specify ODBC SQL query dialog'
in FileMaker then view the statement it generates it's formatted like this:

SELECT 'Salespeople'.'Salesperson_id', 'Salespeople'.'Salesperson' FROM 'Salespeople'

which is not standard.

I've never tried using the FileMaker ODBC driver so I can't tell you if this works but it's worth trying.

Have you tried using the ODBC library with any other database format?

You can get Ability database for loose change and connect to the tables it creates using the MS Access ODBC driver that ships with Windows.

Not only is it a cheap way to go, it actually runs faster than using MS Access own tables with the MS Access ODBC driver.

Better still you could install MySQL http://www.mysql.com

Weave