After PB11 use OLEDB connection ORACLE8i, why not in the SELECT TABLE window shows the synonym TABLE??

After connected with ORACLE8, SELECT the TABLE window can display the list of synonyms, but DATAWINDOW window CROSSTAB connection, display error column order, 5555555555555

CodePudding user response:

With ORACLE8 interface to connect to the database, you can see in the SELECT TABLE window TABLE of synonyms, but there is a problem, DATAWINDOW window display data

PB11 use OLEDB connection ORACLE8i, DATAWINDOW window display data did not have the question, but why not in the SELECT TABLE window shows the synonym TABLE??

CodePudding user response:

How there is no answer??? 55555555555555555

CodePudding user response:

A synonym? Dizzy

It is possible that the connection parameters of the question!

CodePudding user response:

Such as a table name is: comm. Dept_dict, comm is the owner of the table dept_dict

So the synonyms of this table is: DEPT_DICT.

Under normal circumstances, SELECT the TABLE window shows COMM. DEPT_DICT and DEPT_DICT, both names to be displayed,

But after the OLEDB connection database, show only the COMM. DEPT_DICT, don't show DEPT_DICT, such a great trouble to the query table,

555555555555555555

CodePudding user response:

User name or model name that is!
Set in the onwer

CodePudding user response:

Set in the PB???????

How do I didn't find??????? Seek along while also didn't find in the PB (don't tell me in ORACLE Settings)

You carefully read the title??

With ORACLE8 interface to connect to the database, you can see in the SELECT TABLE window TABLE of synonyms, but there is a problem, DATAWINDOW window display data

PB11 use OLEDB connection ORACLE8i, DATAWINDOW window display data did not have the question, but why not in the SELECT TABLE window shows the synonym TABLE??

CodePudding user response:

Now shows the comm. Dept_dict

I want to show dept_dict, and display comm. Dept_dict