Skip navigation
satheesh_p
satheesh_p Calculating status...
Currently Being Moderated

Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]

Oct 12, 2010 10:54 PM

Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Software caused connection abort: recv failed). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server. The specific sequence of files included or processed is: D:\Apps\sitemap.cfm, line: 31

 

We are getting the above error in coldfusion. Can anyone please help us in fixing the above issue?

 

The environment used are as follows:

Coldfusion 9

SQL Server 2005.

 

 

Thanks,

Satheesh.

1486 Views   3 Replies   Latest reply: carl type3, Nov 8, 2010 8:43 PM
 
Replies
  • carl type3
    Currently Being Moderated
    1. carl type3,
    Oct 12, 2010 11:46 PM   in reply to satheesh_p
    Report

    Hi Satheesh,

     

    In CFadmin Data & Services > Data Sources does the Connected Data Sources for your SQL05 database verify?

     

    HTH, Carl.

     
    |
    Mark as:
  • satheesh_p
    Currently Being Moderated
    2. satheesh_p,
    Oct 13, 2010 1:56 AM   in reply to carl type3
    Report

    Thanks for your reply.

    When we verify the connection is successful (Status showing as OK). It doesn't show any error.

     

    Regards,

    Satheesh.

     
    |
    Mark as:
  • carl type3
    Currently Being Moderated
    3. carl type3,
    Nov 8, 2010 8:43 PM   in reply to satheesh_p
    Report

    Hi Satheesh,

     

    Wow this very thing happen to me today at a site. CFAdmin datasource verify OK however could not CFQUERY db. SQL db could not be turned offline.  I restarted SQL Server and everything worked again. Kicking myself a bit - I should have checked thru SQL query what was locking.

     

    Cheers, Carl.

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)