montjoile 0 Light Poster

hi. Im connecting to a oracle network database using power builder 6.0, but I get the following error when I display the window containing the datawindow:

Predefined message "pfc_dwderror" not found.
message arguments:
1)A database error has ocurred
Database error code: 942
Database error code message:
select error: SQLSTATE=S0002
[microsoft][ODBC driver for Oracle][Oracle]ORA-00942: table or view does not exist

this is the odbc script for connection:

SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=xxx;UID=xxx;PWD=xxx;'"

once I try to connect to the database, I get the following error:
"catalog tables could not be created and are not available for use".

The 942 error says that this occurs because I don't have enough privileges to view the tables in the database, but I DO connect to the database, I can update, delete, view, and create new registries. What could be the problem??

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.