Re: Error setting up ODBC connection to Powerbuilder 7.0

[Anne-Marie Matula]

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!