About ODBC Errors
There are two general classes of ODBC errors. One class of errors occurs when ODBC attempts to connect to the data source specified in the ColdFusion application. The second class of errors happens when a SQL statement passed to ODBC by ColdFusion contains a syntax error.
The general form of an ODBC error message returned by ColdFusion is:
ODBC Error Code = [error code] [(error message) ]
[vendor][ODBC_component][data_source]error_message
Hint: [ a description of the possible cause(s) of the problem and
recommended solution(s). SQL= "[sql statement of the CFQUERY that caused the problem]"
Data Source = [data source specified in CFQUERY that caused error ]
