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??