I'm trying to make an ODBC connection from Windows to a file on our FileMaker Server (Mac OS). The specs for both are listed below.

In Windows' ODBC Data Source Administrator, I clicked the 'System DSN' tab, clicked the 'Add' button, and put in the parameters for Server Host, Server Port (2399), and Server Data Source. When clicking 'Test Connect' I receive the message

SequeLink Error: 2306

[DataDirect][ODBC SequeLink driver][sequeLink Client]TCP/IP error, connection refused

Port 2399 is not blocked by the OS X firewall, but the server never opens the port. If I move the file I want to connect to to another machine and share it with a FileMaker Pro client, I am able to make the ODBC connection, so the file is indeed set to be shared. This also indicates the Windows machine is set up properly.

In FileMaker Server Admin under the 'Plug-Ins' section, 'Allow FileMaker Server to use plug-ins' is checked at the bottom. In the 'Configure' section, 'Allow ODBC and JDBC connections' is checked and 250 connections are allowed. We never have more than 10 connections to our server at a time, so it can't be a problem with no connections available. The Summary screen says that ODBC Client Connections are permitted.

If I run '$fmsadmin list plugins' in the Terminal is says that xDBC Data Access Companion is enabled. The xDBC.fmplugin file has permissions of drwxrwxrwx.

At this point I'm unsure of what else to try except reinstalling FileMaker Server. Did I miss any steps here? Is there anything else I can try?

Thanks for any help.

----------

Windows specs:

- Windows XP SP2

- DataDirect SequeLink for ODBC:

( http://fmdl.filemaker.com/MISC/MacOSX/fm_7_win_xdbc_7.0.5.317.zip )

Mac specs:

- Mac OS X 10.3.9 w/all security updates installed

- PowerMac G5 (not Intel)

- FileMaker Server Advanced 8.0v4

Edited August 6, 200718 yr by Guest

I could copy and paste your issue almost exactly except I am dealing with Windows Server 2003 instead, so I, too would love to hear from someone that knows the answer.

Well, I think I've found my problem: http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/popup_adp.php?p_sid=IYld3LIi&p_lva=&p_li=&p_faqid=6451&p_created=1178567005&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9MjA1JnBfcHJvZHM9MCZwX2NhdHM9JnBfcHY9JnBfY3Y9JnBfc2VhcmNoX3R5cGU9YW5zd2Vycy5zZWFyY2hfbmwmcF9wYWdlPTEmcF9zZWFyY2hfdGV4dD1vZGJjIHBvcnQ*

8.0v4 ODBC is incompatible with Mac OS 10.3.9. Bummer.