Discussion:
database/driver problem?
(too old to reply)
DC Gringo
2006-02-09 18:17:55 UTC
Permalink
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
swathi
2006-02-17 16:40:23 UTC
Permalink
Hi,
This is JRun forums. It is better to post this to a Coldfusion forum where
you might have better chances of people answering your question.

Have you tried to use JDBC driver just to check if problem is with Sequelink
or Sql server itself.

Thanks,
Swathi.
Adobe Product Support.

Loading...