I am having the same problem.  I am using MySQL through AWS, connecting with ODBC 32 bit drivers.  I have the current versions of everything as I installed everything today.  I get the catalog table error when connecting to the database, however the 5 catalog tables exist in the schema.  Additionally, when I connect to a MS SQL server, I do not get the error and the tables also exist in SQL.  In both MySQL and SQL the tables are in lower case so not sure what the previous comment was about PC looking for upper case table names.

Hi Peter;

  The key for using the PBCATxxx tables in my setting up of MySQL environment was to make sure that I set the "PowerBuilder Catalog System Owner" in the DB Profile connection settings.

HTH

Regards ... Chris

hi,

i've got the same problem.

mysql server version 8.0.18, mysql odbc-connector 8.0.18, powerbuilder version 2019.2082.

i've created the database root  and set the catalog table owner to root. at the first connection it works and the pb* tables were created. the second and up connection won't work, i've got the message "catalog tables could not be created and are not available for use."

the user connecting to the database has all possible rights for every database at the server.

regards

moritz

Yes, I have the same issues using PB and MYSQL.  Got tired of trying to find the magic configuration so I gave up.  I never connect to the PB tables.

Hi Chris,

once again, this Issue is not resolved and although creating totally new schema's including (imho useless) 'root' schema pb just won't use catalog tables. As I see it, pb is mixing table owners and schema names within connection to database. Why else would we have to set Schema name in Database profile as catalog owner on first connect?

To my dislike logging with odbc trace brings absolutely no hint (see attached dblog.txt  1st Connection with world , 2nd connection as root, 3rd connection nothing set as pbcat owner.

adding a schema 'root' unluckily does't help whatsoever. If I set catalog table owner in db profile to 'root' it works only on first connect once again, resulting in Pbcat tables in both 'world' and 'root' schema. No matter what i set as catalog table owner after that, i get same result that pbcat tables can not be created...

I'm very frustrated, already having spent hours and usless tries creating a usefull PB connection to current MySQL Database 8 with current MySQL ODBC Drivers.

Any help on this matter would really be appreceated!

regards Peter

Hi Peter;

  Yes, I found that reconnecting to the MySQL DB a 2nd time also came up with the same message that the PBCATxxx tables were not there or useable!

  Here is what I did to fix this problem (not a PB issue .. its MySQL), as follows:

MySQLWorkBench: use RHMB on "root" under Table Privileges and select "Create Schema" from pop-up menu!

 Part 2:  Create a new Schema called "root" within your new DB.

My PBCATxxx Table access issue then went away and the PB IDE was able to connect and use the PBCATxxx tables without error.

HTH

Regards ... Chris

I think it may have to to with pbcat tables in schema being lowercase and Powerbuilder looking for Uppercase PBCAT Tables as in following dbtrace log

PB170           31f8-2530    EXIT  SQLTablesW  with return code 0 (SQL_SUCCESS)
        HSTMT               0x047D0CB8
        WCHAR *             0x00000000
        SWORD                        0
        WCHAR *             0x02F93080 [       6] "myschema"
        SWORD                        6
        WCHAR *             0x008FA810 [      -3] "PBCATTBL\ 0"
        SWORD                       -3
        WCHAR *             0x00000000
        SWORD                        0

PB170           31f8-2530    ENTER SQLFetch
        HSTMT               0x047D0CB8

PB170           31f8-2530    EXIT  SQLFetch  with return code 100 (SQL_NO_DATA_FOUND)
        HSTMT               0x047D0CB8

Hi Chris,

not really resolved. Have you disconnected and connected again? Using MySql ODBC 8.0 Unicode Driver 8.00.16.00 against a MySQL Server 8.0.16

On the first connect pbcat... Tables are created without errors or messages coming from PB 2017R3 Build 1880

On disconnect and connect again PB gives Error Message, that Catalog Tables Cannot be Created... Although after that all Tables and its Columns. Views and so forth can be seen in PB IDE Database Browser. Even the pbcat if i select "show system tables".

By the way, same scenario using MySQL ODBC 8.0 Unicode Driver 8.00.16.00 against a MySQL Server 5.6.1.0 gives a total mess up. PB gives Error Message, that Catalog Tables Cannot be Created.... After that all Tables but No Columns can be seen in PB IDE Database Browser.

I've attached Imgae of Log file from ODBC Driver but it doesn't help me much. Can't really see whats going wrong on the PB side.

regards

Pete

Yes, I see all 5 PBCAT tables

MySQL 5.7.21

Connection is through ODBC with MySQL Connector 8.0.13 -win32

I connect fine to the DB, just not the PB catalog tables

Hi James;

   Can you tell us ...

1) MySQL version & build?

2) Type of DB client that you are using to connect to MySQL with?

Regards ... Chris