I am transfering my Cold Fusion CFM files that were
working under NT4 IIS 4 using Cold Fusion Server 4 to the MX ver 7
under Win2003.

I tried to register the mdb using Microsoft Access
driver type in the Administrators page, but I keep
getting the error Unable to Update the ColdFusion MX7
ODBC Server. Timeout Period expired without completion
of C:\...\admin\swcla.exe

So I installed using the Microsft Access with Unicode
driver instead. I can register the database without
error. But when I run the CFM page, I get the error:

Error Executing Database Query. Invalid SQL statement; expected 'DELETE',
'INSERT',
'PROCEDURE', 'SELECT', or 'UPDATE'.

The error occurred in line 27

25 : <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" dbvarname="Mterm"
value="1" null="No">
26 : <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="Mtype"
value="2" null="No">
27 : <cfprocresult name="Bank6Mth">
28 : </cfstoredproc>

--------------------------------------------------------------------------------
SQL {call GetBankMode( (param 1) , (param 2) )}
DATASOURCE CMC
VENDORERRORCODE 3092
SQLSTATE &nbsp;

I am thinking maybe I should use Microsoft Access WITHOUT
Unicode but I cannot figure out how to resolve the
Timeout Period issue.