You'll get more detailed error messages if you enable verbose mode (-v) on
isql: isql -v '*LOCAL'
----- Original message -----
From: Quintin Holmberg <qholmberg@xxxxxxxxxxxxxxxx>
Sent by: "OpenSource" <opensource-bounces@xxxxxxxxxxxxxxxxxx>
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] [IBMiOSS] Could not SQLPrepare
Date: Thu, Jun 4, 2020 1:32 PM
I'm running through some instructions on setting up unixODBC and the ACS
ODBC provider on my IBMi. I've got through it without much of an issue.
At this point I can successfully connect to the system through isql.
When I go to run a simple SQL statement through it, though, I get ...
[ISQL]ERROR: Could not SQLPrepare
Mr. Googlepants was not much help. Where do I look next for an answer?
NOTICE – this email and any attached file (“Information”) may contain
technical data subject to the U.S. International Traffic in Arms
Regulation (“ITAR”) 22 CFR parts 120-130. The Information may not be
shared with any Foreign Person, as that term is defined in ITAR. The
Information is sent only for the use of the intended recipient and may
contain legally privileged and/or confidential information. If you are
not the intended recipient, you are notified that any dissemination or
copying of the Information is prohibited. If you received the
Information in error you must notify the sender immediately and destroy
the Information without printing or saving it.
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.