I have a Win 2008 64 bit server with CF9 32 bit. I have 2 ODBC socket data sources that were working just fine. A change of a static IP address of one of the 2 remote networks caused me to change the IP address of the TelemateSC data source. I used the Windows ODBC data source administrator to change it. Using CF admin to verify the data source gets a time out error. The other data source, TelemateTulsa, still works just fine. The TelemateSC data source tests fine in Windows ODBC data source admin but not under CF. I changed the TelemateSC data source IP address to use the same one as the TelemateTulsa data source and it still times out under CF.
My first suggestion would be to use CF9 64 bit. We had all sorts of issues with the 32 bit version including various freezes and timeouts that we think were caused by inadequate or poorly implemented memory management. A simple query returning more than 4Mb of data will freeze the service. My guess is that this was not a CF issue, but a Java issue. But since CF9 runs under Java, CF gets the black eye.
That's not something we are going to do right away. We tried CF9 64 bit initially but had so much trouble we backed off. This server has been running for some time now. The 2 data sources were fine until I had to change the IP address of one of them. The native MS SQL driver in CF 9 doesn't seem to work either. It tells me it can't be found or is not running.
I've been told that it's better to use a resolvable name for the host address instead of an IP address because CF or Java attempts some sort of reverse lookup to determine the host name. But I'm not totally convinced this is true because we use IP addresses exclusively and have not had any issues. You might try using a host name instead, even if it's a local host name only on the CF server.
Europe, Middle East and Africa