Error Occurred While Processing Request

Error Executing Database Query.

Cannot connect to MySQL server on autonet-prod-mysql.dmz1199.in.canoe.com:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.ConnectException)

The error occurred in \\asgard\bifrost\inetpub\wwwroot\Templates\UsedCarsGraphical.cfm: line 88
Called from \\asgard\bifrost\inetpub\wwwroot\Templates\UsedCarsGraphical.cfm: line 1
Called from \\asgard\bifrost\inetpub\wwwroot\Markville\Preowned.cfm: line 74

86 : 			<cfif isDefined("ListingTypeID") AND ListingTypeID EQ 21>
87 : 				and uc.STOCK_USEDCAR like 'H%'
88 : 		  </cfif>
89 : 		</cfquery>		
90 : 		<!--- HEADER --->

SQL	select count(ID_USEDCAR) as total from TB_USEDCAR uc where uc.ID_ANNONCER in ( select ID_ANNONCER from TB_DEALER where ID_DEALER in ( (param 1) ) ) and uc.ID_USEDCAR_CERTIFIED = 0 and uc.SOLD IS NULL
DATASOURCE	autonet_mysql
SQLSTATE	08S01

Please try the following:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address	38.103.63.16
Referrer
Date/Time	09-May-08 11:33 AM

Stack Trace

at cfUsedCarsGraphical2ecfm499808819._factor18(\\asgard\bifrost\inetpub\wwwroot\Templates\UsedCarsGraphical.cfm:88) at cfUsedCarsGraphical2ecfm499808819.runPage(\\asgard\bifrost\inetpub\wwwroot\Templates\UsedCarsGraphical.cfm:1) at cfPreowned2ecfm1825835673.runPage(\\asgard\bifrost\inetpub\wwwroot\Markville\Preowned.cfm:74)

java.sql.SQLException: Cannot connect to MySQL server on autonet-prod-mysql.dmz1199.in.canoe.com:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.ConnectException)
	at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
	at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown Source)
	at org.gjt.mm.mysql.Driver.connect(Unknown Source)
	at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:559)
	at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:64)
	at java.lang.Thread.run(Thread.java:534)