bburnett
Posts: 22
|
Posted: 06/27/2008, 7:35 AM |
|
I can design a grid with Oracle tables but when I attempt to view the data for an Oracle table via the Visual Query Builder button I get the following error:
ORA-00942: table or view does not exist
This is with my username on the database; when I change the username to the database owner's username and password it works fine.
Also, when we publish the ASP pages and try to run them with my username we get this error:
ADODB.Connection (0xE7A)
Provider cannot be found. It may not be properly installed.
But when we publish the ASP pages with the database owner's name instead of my username it works fine.
I saw another post where they made sure that the Schema was set to the correct database. We have confirmed that that setting is correct; however if we look in the published files it's like that schema value isn't published.
It's as if my username is being put in e.g select * from brandon.sometable
instead of the actual DBO e.g. select * from thedbo.sometable
_________________
Brandon Burnett
New Media Architect
REL Productions
West Des Moines, IA, USA
www.relonline.com |
|
|
bburnett
Posts: 22
|
Posted: 07/09/2008, 12:13 PM |
|
Ok now I am running into the same issue with SQL 2005 which has added the schema level of organization. While I can design forms fine in CCS (after choosing the correct schema for the database connection), once I publish them I get:
Operation is not allowed when the object is closed.
Classes.asp, line 3385
unless I go into the code view and change the select statements so that they include the schema.
e.g.
select * from mytable
becomes
select * from myschema.mytable
Does CCS need to be changed so that schema value in the database connection is inserted in front of the table names in SQL statements or is there some other solution? I've tried adding schema=myschema and other things to the connection string. The username and schema name aren't the same, I've asked the DBA about making them the same.
_________________
Brandon Burnett
New Media Architect
REL Productions
West Des Moines, IA, USA
www.relonline.com |
|
|
bburnett
Posts: 22
|
Posted: 07/09/2008, 12:41 PM |
|
Found the fix for the SQL 2005 problem:
In SQL 2005, change the default schema for those users to myschema. It was at dbo.
Might be the same issue on Oracle.
_________________
Brandon Burnett
New Media Architect
REL Productions
West Des Moines, IA, USA
www.relonline.com |
|
|
|