Solved

Catalog tables could not be created and are not available to use

Posted on 2001-08-27
14
2,414 Views
Last Modified: 2013-12-26
Recently, I installed PB8 and found the error message "Catalog tables could not be created and are not available to use" when I tried to connect to Access database(Access 2000) on Win98SE.  The same problem happended while last time I tried to connect to ASA database using PB7.  Is that a general problem and how to fix it?
0
Comment
Question by:kokan
14 Comments
 
LVL 4

Expert Comment

by:Bhatti
ID: 6431051
Did you try in the Database profile setup ODBC (if you are connecting through ODBC) dialog box to give the name of the Powerbuilder Catalog table owner in system tabpage.

And look in help for catalog tables may brings some positive results.
0
 

Author Comment

by:kokan
ID: 6431092
Bhatti,

What do you mean?  Is that mean I need to supply the name for the PB Catalog table owner field?  What name should i use?  dba?  Actually, I haven't set any password to the database file.

Ken.
0
 
LVL 4

Expert Comment

by:Bhatti
ID: 6432528
Sorry Ken,

What I wrote was nonsence. I just thought about the ODBC connection to SQL-Anywhere.

I think you should look the ODBC Driver first. Is it update etc. and the ODBC connection to Access.

Secondly look the DBA-rights for the system tables. May be due to the less rights not creating the catalog tables.

Please let me know after this check.

THANKS
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 4

Expert Comment

by:Bhatti
ID: 6441226
What about catalog tables?
0
 

Author Comment

by:kokan
ID: 6443242
Hi Bhatti,

Still can't be created.  I've tried to download DAC from microsoft but no effect after installed.  I've checked with PB installation and found that no ODBC driver for MS Access is included.

Really feel frustrated with it.  I wonder why so little response on it.  I don't think the problem only happended in PB8 only.

Ken.
0
 

Expert Comment

by:DrVannacult
ID: 6444184
Hi, Bhatti & kokan

My PB8 Eval that installed with all ODBC drivers is sames as ur... But in the present I've uninstalled PB8 Eval and install PB7.0 It's work great! without that catalog tables message...

That's my experiences
Luck!

Listening on answers...
8)
drvannacult
0
 

Author Comment

by:kokan
ID: 6444214
Dear drvannacult,

Yes, it works fine in PB7.  But coz' i just upgraded to pb8, I don't want to fallback.

However, I have come across the same message when I using the PB 7 with ASA.  So it should be not version dependent but PB version plus database version dependent!

Hope that someone can help!

Regards,

Ken.
0
 
LVL 4

Expert Comment

by:Bhatti
ID: 6444282
Hello Ken,

Did you find ODBC driver for MS Access?

For Access is most important is ODBC Driver. I wrote, did you check the DBA rights. May brings some positive results.
0
 

Author Comment

by:kokan
ID: 6449504
Dear Bhatti,

I've checked, and tried use admin account but still got the message.  For ODBC driver, I don't know where to download.  I've installed the most updtead MDAC from Microsoft, but still can't fix the problem.  Please advise where to download the driver.  Thanks.

Ken.
0
 
LVL 4

Expert Comment

by:Bhatti
ID: 6450091
Hi Ken,

I think you can try by www.mocrosoft.com in the "download center" section.
0
 
LVL 4

Expert Comment

by:Bhatti
ID: 6576098
Hallo Kokan,

Recently I was loking for connection to the Access database, I checked that it depends on the version of the odbcjt32.dll file. (Or you already fixed your probem). Please let me know.


THANKS


Bhatti
0
 

Author Comment

by:kokan
ID: 6630520
Hi Bhatti,

The problem disappeared when I applied the new patch for PB8.

Thanks

Ken
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 11448776
PAQed, with points refunded (50)

modulo
Community Support Moderator
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
JTable - Group/UnGroup/Drag&Drop 2 109
HTML-Kit Question 5 102
Online file editor, manager 6 98
what is the best Integrated development environment 2 35
In our object-oriented world the class is a minimal unit, a brick for constructing our applications. It is an abstraction and we know well how to use it. In well-designed software we are not usually interested in knowing how objects look in memory. …
Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question