FM8 ODBC connection failure

[Hugh Murray-Walker]

In the Win XP Control Panels/Administrative Tools/Data Sources ODBC I can make a successful ODBC connection to my database when hosted by FMP7 or FMD7 but not when hosted by FMP8 or FMPA8.... aaargh! The message I get is "SequelLink Error: 2309 ... TCP/IP connection refused"

Has anyone else come across this?

I'm using the DataDirect 32-BIT SequekLink 5.4 ODBC driver as supplied on my FMPA8 installation disk.

I'm read, reread and reread the instructions in the FMPA8 developers guide and I can see no difference in the set up from version 7. I've checked a 100 times that the file is set to share via ODBC, I've even tried uninstalling and reinstalling the driver and rebooting the machine to no avail.

I open the file in version 7 and I can connect via the Data Sources window, open it in version 8 and I cannot.

Has anyone on the list made a successful ODBC connection to a file hosted by version 8? Was there ay difference in the set up from version 7?

Kind regards,

Hugh

[rejoice]

I have exactly the same configuration and facing the same problem except my error code is 2306. This is very frustrating since it worked in FM 7. Hope someone has an answer.

[Jeffrito Bandito]

Same story ... although I _can_ make a connection to a locally shared file using localhost. No luck connecting to Server 8 for Windows.

Did you ever get anywhere with your problem?

[B Campbell]

I am hosting a database on OS X Tiger Server edition and accessing it from a Windows 2000 computer via ODBC rather then hosting it on Windows as you describe. With this setup i have had no issues making the ODBC connection.

I used the same firewall ports as with the FM 7 setup. I did however use the new FM 8 plug in as well as the new ODBC driver supplied on FM 8 Server installation disks.

I do seem to remember seeing those error numbers while configuring my FM 7 configuration and i believe it was either a firewall port or a permissions that was causing it.

Hope that helps.

[John May - Point In Space]

FYI, ODBC connections are working fine for us here on FMSA8 running on Mac OS X.

- John

[drumhead52]

we were getting error 2306 because FMServer Plugin wasn't opening port 2399 on OSX server, replaced xDBC Support folder from another working server (make sure permissions are correct on new folder) that fixed error 2306