MySQL Forums
Forum List  »  Connector/ODBC

Re: Error setting up ODBC connection to Powerbuilder 7.0
Posted by: Anne-Marie Matula
Date: December 07, 2018 09:41AM

I found a solution - so thought to share.

MySQL dump .sql files may create objects that are not compatible with 32 bit Powerbuilder 7.0.

These are 2 lines from the .sql dump file that I had received that seemed to cause problems:
/*!40000 ALTER TABLE (table name) DISABLE KEYS */;
/*!40000 ALTER TABLE (table name) ENABLE KEYS */;

I ran the Kuali dump .sql file without those lines and still received the 22018 error.

The solution I found was:

Run the .sql dump script (without the lines above).
The drop each table in MySQL
Run the part of the dump script that creates each table (without the lines above)

And Powerbuilder then successfully does a select *
So there must be something else in the scripts (other than those 2 lines above) that PB does not like (?)

In any event, I am effectively connecting to the MySQL database in Powerbuilder which is awesome!

I love MySQL!

Options: ReplyQuote

Written By
Re: Error setting up ODBC connection to Powerbuilder 7.0
December 07, 2018 09:41AM

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.