Skip navigation
Currently Being Moderated

CF data source timed out

Jan 5, 2012 7:13 AM

Tags: #mssql #coldfusion

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.

 
Replies
  • Currently Being Moderated
    Jan 5, 2012 9:05 AM   in reply to larksys

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 5, 2012 9:23 AM   in reply to larksys

    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.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points