Skip to main content
L
lilyaw111
Participant
July 29, 2011
Question

database connection failure

  • July 29, 2011
  • 1 reply
  • 792 views

CFMX7, SQL SERVER 2005

SQL server database was migrated to a vmware server.

This is the error got when our network engineer changed the sql server IP address in the CF admin site:

Connection verification failed for data source:

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]No more data available to read.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]No more data available to read.

help appreciated.

    This topic has been closed for replies.

    1 reply

    A
    Adam Cameron.
    Inspiring
    August 14, 2011

    CFMX7 is pretty old... have you tried upgrading your JDBC drivers?

    In what situations does this happen?  Every time you connect to the DB, or sometimes, or when running specific actions?

    Have you googled the error message and worked through the mountain of discussion on the topic (granted, the signal to noise ratio is high, but there's a lot of stuff there).  If you haven't googled: you should be doing that first.  If you have: what have you tried?

    Can you telnet onto the SQL Server box from the CF box using the IP address & port in question?  Can you connect to the SQL Server box from the CF box using SQL's client tools (like query analyser), using the same IP address and port AND the same credentials?

    --

    Adam

    L
    lilyaw111Author
    Participant
    August 15, 2011

    Thank you for your response Adam, it turns out there was a firewall issue that caused the db not to connect to the cf server.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices