DC Gringo
2006-02-09 18:17:55 UTC
Out of nowhere I started having database connection problems both my stage
and production servers. I have CFMX 6.1 with latest updater, SQL Server 2k
and Win2k with latest service packs. I'm getting two different errors and
then having to stop the swoc.exe process to stop the CPU from sticking at
100% and then have to restart to get any db connections to work. It often
happens upon clicking on a second .cfm page that calls to the database.
A Stored Procedure has failed
[Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused. HY000
A Stored Procedure has failed
[Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data
source is not defined. n/a
Verifying the connection in the CF Administrator works fine.
This connection has been set up for over a year using odbc socket with a
trusted connection. I've tried switching to a SQL Server connection with
SQL user rather than trusted with no luck. In fact, I can't even get the CF
Administrator to verify that connection. I tried upgrade the sequelink
driver on one machine, but that didn't seem to work either...any
suggestions?
Please help, getting desperate here!!
_____
DC G
and production servers. I have CFMX 6.1 with latest updater, SQL Server 2k
and Win2k with latest service packs. I'm getting two different errors and
then having to stop the swoc.exe process to stop the CPU from sticking at
100% and then have to restart to get any db connections to work. It often
happens upon clicking on a second .cfm page that calls to the database.
A Stored Procedure has failed
[Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused. HY000
A Stored Procedure has failed
[Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data
source is not defined. n/a
Verifying the connection in the CF Administrator works fine.
This connection has been set up for over a year using odbc socket with a
trusted connection. I've tried switching to a SQL Server connection with
SQL user rather than trusted with no luck. In fact, I can't even get the CF
Administrator to verify that connection. I tried upgrade the sequelink
driver on one machine, but that didn't seem to work either...any
suggestions?
Please help, getting desperate here!!
_____
DC G