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.DBMS = "ODBC"
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??
