?
Solved

tcAccess

Posted on 2004-09-21
8
Medium Priority
?
492 Views
Last Modified: 2013-12-24
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::executeSQLTagCFQuery::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\Intranet\lowesfoods\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_REPORTING_CONF
</cfquery>
0
Comment
Question by:psenn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 17

Expert Comment

by:anandkp
ID: 12112733
if thats the entire page - i wonder why the error is on line 18

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_CONF
</cfquery>
0
 
LVL 35

Expert Comment

by:mrichmon
ID: 12113033
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....
0
 

Author Comment

by:psenn
ID: 12113638
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\Intranet\lowesfoods\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_REPORTING_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_REPORTING_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....
0
Optimum High-Definition Video Viewing and Control

The ATEN VM0404HA 4x4 4K HDMI Matrix Switch supports 4K resolutions of UHD (3840 x 2160) and DCI (4096 x 2160) with refresh rates of 30 Hz (4:4:4) and 60 Hz (4:2:0). It is ideal for applications where the routing of 4K digital signals is required.

 
LVL 14

Expert Comment

by:Renante Entera
ID: 12119058
Hello psenn!

Regarding the error "PCodeRuntimeContextImp::executeSQLTagCFQuery::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 :-)
0
 
LVL 17

Expert Comment

by:anandkp
ID: 12120365
is the installation of CF Server all fine ...
can u just test a sample query & see if that works ...
0
 

Author Comment

by:psenn
ID: 12203576
It looks like it was a tcAccess driver problem.
0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 12227240
Question answered by asker or dialog valuable.
Closed, 250 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
0

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question