MySQL Forums
Forum List  »  Connector/ODBC

Error setting up ODBC connection to Powerbuilder 7.0
Posted by: Anne-Marie Matula
Date: December 05, 2018 10:54AM

I set up a 32 bit ODBC connection to MySQL Server within Powerbuilder 7.0. I tried both ANSI and Unicode and received this error in both when I ran a select * on a table in Powerbuilder

Select error: SQLSTATE 22018
[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.24-log]

The error with a select * results in not all records being extracted.

I identified the culprits where the error is triggered, a varchar[500] field and a mediumtext (containing JSON) field.

So if I select all but those 2 fields all records are extracted.

I looked at the data and do not see what is causing the problem.

Interesting querying in DESC order extracted nothing:

select id, displaydescription from actions
order by id DESC;

Does anyone have any idea what the issue can be?

I appreciate your time and help!

Options: ReplyQuote

Written By
Error setting up ODBC connection to Powerbuilder 7.0
December 05, 2018 10:54AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.