Actually I made some progress:
I tried this and it failed:
SELECT * FROM AMFLIB.CUSMAS;
Then I tried taking the semicolon away and it returned OK:
SELECT * FROM AMFLIB.CUSMAS
I'm thinking it's the 3rd party app that is the culprit.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave
Sent: Monday, June 22, 2009 2:51 PM
To: Midrange Systems Technical Discussion
Subject: re: Client Access ODBC Driver
What sort of error message are you getting?
----------------------------------------
From: "ibm" <ibm@xxxxxxxxxx>
Sent: Monday, June 22, 2009 12:46 PM
To: MIDRANGE-l@xxxxxxxxxxxx
Subject: Client Access ODBC Driver
I am able to make a connection to the ODBC DSN but issuing any SELECT
statements fails.