kokan
asked on
Catalog tables could not be created and are not available to use
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?
ASKER
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.
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.
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
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
What about catalog tables?
ASKER
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.
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.
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
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
ASKER
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.
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.
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.
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.
ASKER
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.
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.
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
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
ASKER
Hi Bhatti,
The problem disappeared when I applied the new patch for PB8.
Thanks
Ken
The problem disappeared when I applied the new patch for PB8.
Thanks
Ken
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
And look in help for catalog tables may brings some positive results.