Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.

The error occurred in E:\WEB\duckmusic\cfscripts\leftnav.cfm: line 82
Called from E:\WEB\duckmusic\cfscripts\leftnav.cfm: line 40
Called from E:\WEB\duckmusic\cfscripts\leftnav.cfm: line 25
Called from E:\WEB\duckmusic\cfscripts\leftnav.cfm: line 1
Called from E:\WEB\duckmusic\duckmaster.cfm: line 664
Called from E:\WEB\duckmusic\duckmaster.cfm: line 588
Called from E:\WEB\duckmusic\duckmaster.cfm: line 402
Called from E:\WEB\duckmusic\duckmaster.cfm: line 1

80 : 		 from triviacontest
81 : 		 where status = 1
82 : 		 and triviacontestindex in (select contestindex from artistcontest where artistindex = #thisartist#)
83 : 		order by triviacontestindex desc
84 :

SQL	select triviacontest.* from triviacontest where status = 1 and triviacontestindex in (select contestindex from artistcontest where artistindex = 685) order by triviacontestindex desc
DATASOURCE	promo
VENDORERRORCODE	-1024
SQLSTATE	HY000

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	ColdFusion
Remote Address	63.74.120.230
Referrer
Date/Time	18-Feb-05 11:17 PM

Stack Trace

at cfleftnav2ecfm504136819._factor2(E:\WEB\duckmusic\cfscripts\leftnav.cfm:82) at cfleftnav2ecfm504136819._factor6(E:\WEB\duckmusic\cfscripts\leftnav.cfm:40) at cfleftnav2ecfm504136819._factor7(E:\WEB\duckmusic\cfscripts\leftnav.cfm:25) at cfleftnav2ecfm504136819.runPage(E:\WEB\duckmusic\cfscripts\leftnav.cfm:1) at cfduckmaster2ecfm665740071._factor10(E:\WEB\duckmusic\duckmaster.cfm:664) at cfduckmaster2ecfm665740071._factor15(E:\WEB\duckmusic\duckmaster.cfm:588) at cfduckmaster2ecfm665740071._factor18(E:\WEB\duckmusic\duckmaster.cfm:402) at cfduckmaster2ecfm665740071.runPage(E:\WEB\duckmusic\duckmaster.cfm:1)

java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
	at macromedia.sequelink.ssp.Diagnostic.toSQLException(Unknown Source)
	at macromedia.sequelink.ssp.Chain.cnvDiagnostics(Unknown Source)
	at macromedia.sequelink.ssp.Chain.decodeDiagnostic(Unknown Source)
	at macromedia.sequelink.ssp.Chain.decodeBody(Unknown Source)
	at macromedia.sequelink.ssp.Chain.decode(Unknown Source)
	at macromedia.sequelink.ssp.Chain.send(Unknown Source)
	at macromedia.sequelink.ctxt.conn.SessionContext.logon(Unknown Source)
	at macromedia.sequelink.ctxt.conn.SessionContext.<init>(Unknown Source)
	at macromedia.sequelink.ctxt.conn.ConnectionContext.connect(Unknown Source)
	at macromedia.jdbc.sequelink.SequeLinkImplConnection.open(Unknown Source)
	at macromedia.jdbc.slbase.BaseConnection.getNewImplConnection(Unknown Source)
	at macromedia.jdbc.slbase.BaseConnection.open(Unknown Source)
	at macromedia.jdbc.slbase.BaseDriver.connect(Unknown Source)
	at macromedia.jdbc.MacromediaDriver.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)