Error::Catalog tables could not be created...

[smile76]

Hi Friends

I am working in PB8 and have OfficeXP
when i create a profile in PB8 and connecting with
Ms Access through ODBC connection and in priview tab
when i click for test connection then the following
message appear

***Catalog tables could not be created and are not available for use*****

this is all right with MS SQL server but only problem with
MS Access Kashif Ibrar
Software Engineer
SOLINCS Pakistan Lahore

 

[katatagan]

In the Database Profile Setup window, select the System tab and provide the PowerBuilder Catalog Table Owner. I don't know the default owner for these PB system tables in MS Access. In my case, I make SYSTEM as the owner for my ORACLE database.

I hope this will help.

 

[katatagan]

Usually, the PB Catalog Owner is also the default owner for the DBMS. If you specify another owner, PowerBuilder will create a new set of tables for that owner. This means that it is possible to have multiple PB extended attributes system tables in a database.