We are experimenting with a product called tcAccess to get to our mainframe data.
In CF admin, when I press the "verify" link in ODBC data sources, it returns
"The connection to the data source was verified successfully."
So all is well it would seem.
However, in my program, when I try to SELECT from that datasource, I get the following:
unknown exception condition
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (18:2) to (18:44) in the template file D:\InetPub\wwwroot\Intranet\lowesfoods\tcorder_conf.cfm.
I've stripped out EVERYTHING except the cfquery, so there's no session variables.
Here's the entire page:
<cfquery name="OC" datasource="tcMHKYCICS">
SELECT * FROM ADMIN.TCACCESS_MDI_OC_REPORTING_CONF