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

Forum|Forum|15 years ago
October 13, 2010
1 reply
4410 views

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.

Database access

This topic has been closed for replies.

C

carl type3

Legend

Hi Satheesh,

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

HTH, Carl.

S

satheesh_pAuthor

Inspiring

Thanks for your reply.

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

Regards,

Satheesh.

C

carl type3

Legend

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.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded