ODBC link issue with Filemaker Pro 9

[Micah E]

I’ve been trying to create an ODBC link to Filemaker 9 Pro on my Mac here at the office to build some quick printable reports in PHP, but the ODBC set up has been killing me. I’m wondering if you have any ideas or solutions as to my problem.

I’ve followed the documentation included with Filemaker perfectly (I think so, anyway!), set up the ODBC driver off the xdbc folder on the Filemaker CD, opened Filemaker, and shared the database. The error that is returned after I do an iodbctest is clearly a driver error:

Enter ODBC connect string (? shows list) Driver=Sequelink;DBQ=AlturaDB;UID=admin;password=XXXXX (masked, not sic!)

1: SQLDriverConnect = [iODBC][Driver Manager]dlopen(Sequelink, 6): image not found (0) SQLSTATE=00000

2: SQLDriverConnect = [iODBC][Driver Manager]Specified driver could not be loaded (0) SQLSTATE=IM003

Here are my driver configuration details from odbcinst.ini:

[sequelink]

Driver = /Library/ODBC/SequeLink.bundle/Contents/MacOS/ivslk20.dylib

Setup =

Host = localhost

Port = 2399

And from odbc.ini:

[ODBC Data Sources]

AlturaDB = Sequelink

[AlturaDB]

Description = EMFS DB 1-9-08

host = localhost

port = 2399

ServerDataSource = AlturaCap09Jan2008

I have Filemaker Pro 9 running and sharing the database over ODBC during all this, too.

I know Filemaker Server 9 has a PHP API that’s much easier to use than the ODBC connection, but I only have Filemaker Pro 9. Do you have any insights on a workaround for this problem, or maybe what I’m doing wrong with my ODBC driver setup?

[oleung]

Hi, I encountered similar problem and not clue on setting up the FMP9 ODBC driver in Mac.

Windows environment is fine.

Please advise what does this means on the setup.

[sequelink]

Driver = /Library/ODBC/SequeLink.bundle/Contents/MacOS/ivs lk20.dylib

Setup =

Host = localhost

Port = 2399

And from odbc.ini:

[ODBC Data Sources]

AlturaDB = Sequelink

[AlturaDB]

Description = EMFS DB 1-9-08

host = localhost

port = 2399

ServerDataSource = AlturaCap09Jan2008

**********

Where can I get his section setup?

I am frustrating.

*********

Thanks,

[Sefu]

...both of you may notice that you have an extra space in your file name: it should be 'ivslk20.dylib' and not 'ivs lk20.dylib'.

[Garry Claridge]

Remove the "ServerDataSource" from the ini file.

All the best.

Garry