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 dataPB11 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??? 55555555555555555CodePudding user response:
A synonym? DizzyIt 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_dictSo 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_dictI want to show dept_dict, and display comm. Dept_dict