psenn
asked on
tcAccess
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
PCodeRuntimeContextImp::ex ecuteSQLTa gCFQuery:: endTag
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\Intrane t\lowesfoo ds\tcorder _conf.cfm.
I've stripped out EVERYTHING except the cfquery, so there's no session variables.
Here's the entire page:
<html><body>
<cfquery name="OC" datasource="tcMHKYCICS">
SELECT * FROM ADMIN.TCACCESS_MDI_OC_REPO RTING_CONF
</cfquery>
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
PCodeRuntimeContextImp::ex
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\Intrane
I've stripped out EVERYTHING except the cfquery, so there's no session variables.
Here's the entire page:
<html><body>
<cfquery name="OC" datasource="tcMHKYCICS">
SELECT * FROM ADMIN.TCACCESS_MDI_OC_REPO
</cfquery>
That can't be the entire page because you are missing a closing html and body.
Try as anand said of removing the admin. from the table name
Also post the whole page....
Try as anand said of removing the admin. from the table name
Also post the whole page....
ASKER
I admit that I was sloppy on my cut & paste of the error page.
That was from the original page before I started stripping everything out to simplify the problem.
The real line number is line 2
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:43) in the template file D:\InetPub\wwwroot\Intrane t\lowesfoo ds\tcOrder _conf.cfm.
You don't need closing html and body tags, so the whole page really is:
<html><body>
<cfquery name="OC" datasource="tcMHKYCICS">
SELECT * FROM ADMIN.TCACCESS_MDI_OC_REPO RTING_CONF
</cfquery>
But just to make sure everything was checked, I did add </body> and </html>.
There is an application.cfm, but it only contains comments.
There is a site_error.cfm that is quite large however.
I think the problem is on the mainframe side, but it's hard to say for sure.
I tried taking out the ADMIN. part per anandkp's suggestion, and it gave a different error message.
tcACCESS][ODBC Driver] 00000000209A5839 Host tcACCESS SQL error No authorization for: 'SQL_TCACCESS_MDI_OC_REPOR TING_CONF' s
I think I'm going to have to ask my mainframe guy to call tcAccess technical support.
I'll let you know how that goes....
That was from the original page before I started stripping everything out to simplify the problem.
The real line number is line 2
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:43) in the template file D:\InetPub\wwwroot\Intrane
You don't need closing html and body tags, so the whole page really is:
<html><body>
<cfquery name="OC" datasource="tcMHKYCICS">
SELECT * FROM ADMIN.TCACCESS_MDI_OC_REPO
</cfquery>
But just to make sure everything was checked, I did add </body> and </html>.
There is an application.cfm, but it only contains comments.
There is a site_error.cfm that is quite large however.
I think the problem is on the mainframe side, but it's hard to say for sure.
I tried taking out the ADMIN. part per anandkp's suggestion, and it gave a different error message.
tcACCESS][ODBC Driver] 00000000209A5839 Host tcACCESS SQL error No authorization for: 'SQL_TCACCESS_MDI_OC_REPOR
I think I'm going to have to ask my mainframe guy to call tcAccess technical support.
I'll let you know how that goes....
Hello psenn!
Regarding the error "PCodeRuntimeContextImp::e xecuteSQLT agCFQuery: :endTag".
You can view the site http://www.macromedia.com/support/coldfusion/ts/documents/tn18017.htm for some information and guide on how to avoid this unknown exception error.
In addition to that, better double-check your database permission also.
Goodluck!
eNTRANCE2002 :-)
Regarding the error "PCodeRuntimeContextImp::e
You can view the site http://www.macromedia.com/support/coldfusion/ts/documents/tn18017.htm for some information and guide on how to avoid this unknown exception error.
In addition to that, better double-check your database permission also.
Goodluck!
eNTRANCE2002 :-)
is the installation of CF Server all fine ...
can u just test a sample query & see if that works ...
can u just test a sample query & see if that works ...
ASKER
It looks like it was a tcAccess driver problem.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
cld u see around this line no - or post the code - so we cld look at it & try & help out ...
also check u may have other includes in this template or application.cfm ... try & check on those as well
make sure there are no syntatical errors wrt the "quotes"
try
<cfquery name="OC" datasource="tcMHKYCICS">
SELECT * FROM TCACCESS_MDI_OC_REPORTING_
</cfquery>