×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Also if you can share the query you're running that might be interesting.
I always test with: select * from qiws.qcustcdt
Regards,
Richard Schoen
Web:
http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
Phn: (612) 315-1745
----------------------------------------------------------------------
message: 2
date: Thu, 4 Jun 2020 18:45:58 +0000
from: "Kevin Adler" <kadler@xxxxxxxxxx>
subject: Re: [IBMiOSS] Could not SQLPrepare
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>
Cc:
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?
Thanks,
Quintin Holmberg
midrange.com
