Error Executing Database Query.

Server connection failure during transaction. Due to underlying exception: 'com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database 'ads''. ** BEGIN NESTED EXCEPTION ** com.mysql.jdbc.exceptions.MySQLSyntaxErrorException MESSAGE: Unknown database 'ads' STACKTRACE: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database 'ads' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2924) at com.mysql.jdbc.Connection.<init>(Connection.java:1555) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:559) at coldfusion.server.j2ee.sql.pool.ConnectionRunner$R...

The error occurred in C:\CFusionMX\CustomTags\AdBanner.cfm: line 28

26 : ïÚèÎìýNÎ¹¸zï×œ€QÇð|w7ÅÛp/ª;ŸË+¼XmýŠ%Cƒ—_@Ûñîº¹÷i¦••öà'oöº·ÌÉÌËéÀ¸h@:!Òây?‹È±ËÇ¯h‘VIã?#•À[8’œ‰¯2¨ðL�»°Þ”Qñ™Ù•z’¼°%ß¬ñ“ò�GS÷M…Ô³œu|æåë¼“®ã"›¶
27 : †° èôJÆM_Èè{·³
28 : ïÚèÎìýNÎ¹¸zï×œ€QÇð|w7ÅÛp/ª;ŸË+¼Xmý"á¹k˜VËª´„êqY+š±Ìµ"ìˆsØüäÖXtL��$ùäJÖk¢!¢¥¡bjx‘\k¥¼œðýÊ)“Éæ·"\2�¥ež§äÁn•'J4œ§}Ý	Øóé»cÝ¶«æá¡«ÄdýÖ÷^.©2’ÃþIÇI�öØŽìèÒî`â�ä’Ø]>².á;|%Ý‰
29 : ÃÄÁÿám¿îíˆXnù¡9£Ö[¯}GÙñwÐ3ø˜tÝôÉ¡qCJ½ÀþúÅ�•“r#‹æNßzQ9Èå…DŽˆŒ-dpNy7„$ß¬¤S¨v2›0t ýŠn÷dIDŽˆŒ-dpNy7„$ß¬ÂÁeQþëØ•±B\®ÚÎ}…ù¯R,7Ég—ÖÿË
30 : BŸ&�dÏp°Å•¯Áé³ý²DŸïbÃÿAÑð®J(Ó“ÆV°Kï<ê¾¥_û¸°‰Â 'í

SQL	SELECT name, ad_id, filename, path, href, alt from ads, ad_category_link, category WHERE category_name = 'Investment - Home' AND category_id = category_link AND ad_id = ad_link AND active = 1
DATASOURCE	ads
SQLSTATE	08001

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.17
Referrer
Date/Time	12-May-08 02:01 PM

Stack Trace

at cfAdBanner2ecfm707235327.runPage(C:\CFusionMX\CustomTags\AdBanner.cfm:28) at cfindex2ecfm1882495149.runPage(D:\wwwroot\southpacificnews\kids\index.cfm:29)

com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database 'ads''.

** BEGIN NESTED EXCEPTION ** 

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException
MESSAGE: Unknown database 'ads'

STACKTRACE:

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database 'ads'
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2924)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	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)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up.
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2997)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	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)