Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved catalog tables could not be created

  1. Issue
0
Votes
Undo
  1. moritz nölting
    moritz nölting
  2. PowerBuilder
  3. Friday, 6 March 2020 09:34 AM UTC

hi,

i have the latest build of PB (2019.2170) on windows 10.  i'm using MySQL (8.0.19) db and have the aggravating issue of not being able to generate or use the system catalog tables.  i've tried blank, root and the name of the database in the table owner field on the DB profile with no success.  i can access my tables and connect easily - just not the PB tables.

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

Catalog tables could not be created and are not av...
dw.insertrow(0) returns -1
Responses (2)
moritz nölting
moritz nölting Accepted Answer Pending Moderation
  1. Monday, 9 March 2020 06:46 AM UTC
  2. PowerBuilder
  3. # 1

hi,

that way doesn't work.

i posted it also in that thread.

 

regards

moritz

Comment
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Friday, 6 March 2020 14:34 PM UTC
  2. PowerBuilder
  3. # 2

Hi, Moritz -

See if this helps you:

https://community.appeon.com/index.php/qna/q-a/catalog-tables-could-not-be-created

Regards, John

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 6 March 2020 17:27 PM UTC
Hi John .. thanks for pointing out my answer. ;-)
  1. Helpful
moritz nölting
  1. moritz nölting
  2. Monday, 9 March 2020 06:55 AM UTC




hi,



that way doesn't work.



i posted it also in that thread.







regards



moritz

  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 9 March 2020 14:00 PM UTC
Hi Moritz ... Sorry that my procedure did not work for you. Unfortunately, MySQL is *not* supported by PowerBuilder at this time. I would recommend having a look at Postgres instead. Regards ... Chris
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.