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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.