ODBC Stopped working when DB moved to different machine

[uemtux]

So I run several databases, they're hosted by FileMaker Server 11. The clients are a mix of FileMaker 8.5, 9, and 10 Pro. One of the DBs I connect to via ODBC from 2 different PCs. This worked perfectly until I switched servers.

The original server was a Mac Pro running 10.5 Server, it decided to have a massive spectacular hardware failure today, so I installed FMS11 on another server machine, this one a Mac Mini running 10.6 server. This has worked fine for everything else. Everyone is connecting to the other databases via FM protocol no problem.

However, ODBC doesn't work. The server console shows that the file is shared via ODBC, it is readable and writeable by everyone (same for the xDBC plugin file and folder) and there doesn't even seem to be a network problem. If I telnet to the server on the ODBC port (in windows cmd line "telnet 192.168.2.XXX 2399") I get a successful connection and a bunch of characters that are probably part of some ODBC handshake.

But, when I'm going through the System DSN configuration for the FileMaker ODBC driver (off the FM11 disc) when I try to get the list of databases from the host I get a can't connect message. I'm entering the correct address. There's no firewall on the server... what the heck could be going on?

Thanks for your help, experts... :)