Confused....

I recently switched from a site we were hosting ourselves on CF MX to one
that is using either CF 8 or MX 7.02. I set up DSN to my database, and it
appears to ahve worked, but on almost every page (at least the ones I've
tried) I get an error.

The latest one is shown below, and I'm not sure what the problem is. Can
anyone suggest what direction to look?

The query is:
<cfquery name="Confirmed" datasource="SalleBoise">
select u_fName,
u_lName,e_foil,u_club,u_uuid,e_foil_rating,e_foil_year,tournevent.e_epee,e_epee_rating,e_epee_year,c_full_name
from tournfencer left outer join tournevent
on tournfencer.u_id=tournevent.e_id
left outer join tournclub
on tournfencer.u_club=tournclub.c_name
where e_tid=<cfqueryparam cfsqltype="cf_sql_integer" value="#url.tid#"
maxlength="3">
order by u_lName
</cfquery>

Thanks.


Error Executing Database Query.
Communications link failure due to underlying exception: ** BEGIN
NESTED EXCEPTION ** java.net.ConnectException MESSAGE: Connection refused:
connect STACKTRACE: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method) at
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at
java.net.Socket.connect(Socket.java:519) at
java.net.Socket.connect(Socket.java:469) at
java.net.Socket.(Socket.java:366) at java.net.Socket.(Socket.java:208) at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:173)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:267) at
com.mysql.jdbc.Connection.createNewIO(Connection.java:2739) at
com.mysql.jdbc.Connection.(Connection.java:1553) at
com.mysql.jdbc.NonRegistering...

The error occurred in D:\home\salleboise.com\wwwroot\confirmed.cfm:
line 12

10 : left outer join tournclub
11 : on tournfencer.u_club=tournclub.c_name
12 : where e_tid=<cfqueryparam cfsqltype="cf_sql_integer" value="#url.tid#"
maxlength="3">
13 : order by u_lName
14 : </cfquery>


--------------------------------------------------------------------------

SQLSTATE 08S01
SQL select u_fName,
u_lName,e_foil,u_club,u_uuid,e_foil_rating,e_foil_year,tournevent.e_epee,e_epee_rating,e_epee_year,c_full_name
from tournfencer left outer join tournevent on
tournfencer.u_id=tournevent.e_id left outer join tournclub on
tournfencer.u_club=tournclub.c_name where e_tid= (param 1) order by u_lName