PowerBuilder how to create catalog tables

Question

I am starting to use PowerBuilder on a new Microsoft SQL Server 2000 r2. I know that I should create catalog tables in the database like pbcatcol etc, but I have not been able to find a script to do that. It is not installed in the PowerBuilder directory tree, it should be a .sql file, and probably a different version for every supported database. Where can I find it?

Answer 1

Terry has right. It happened to me, that we used a different schema than dbo, and we need to set the schema here: Database Profile Setup/System tabpage/Powerbuilder Catalog Table Owner

If it was not set, PB could not create these tables.

Br. Gábor

Answer 2

Actually, this will happen for you automagically from the IDE; it will create the catalog tables for you. I'm not certain if it's the first time you connect to the database, or the first time you open the DataWindow painter or save from the DataWindow painter, but they end up there on their own (after you've supplied the connection parameters, of course).

Good luck,

Terry.