hatch79
|
| Posted: 11/12/2003, 7:17 AM |
|
I am trying to create an app using Oracle for the DB. When I create the connection string CCS recognizes the tables and fields, but when I try to create a page and display it, I get the following error message:
Form: Grid EQUIPMENT_MASTER
Error: ORA-00942: table or view does not exist
SELECT * FROM EQUIPMENT_MASTER
Thanks in advance for any help.
|
|
|
 |
Doug
|
| Posted: 11/12/2003, 8:41 AM |
|
One idea. The account that created the table is different from the account you are using to access using CC. For example is dbadmin created the table and you are logged in using dbuser, you have to
SELECT * FROM DBADMIN.EQUIPMENT_MASTER
Hope this helps.
Doug
|
|
|
|
hatch79
|
| Posted: 11/12/2003, 12:54 PM |
|
Thanks Doug, you are absolutely correct. Do you know how to get CCS to fully qualify fields without doing it by "hand"?
|
|
|
|
RonB
|
| Posted: 11/13/2003, 12:20 AM |
|
Did you set the schema in the connection string? (the advanced tab). That solved the problem at my company. Also always check if the user used in the connection has the right priveleges.
Ron
|
|
|
|
|
