Will Muenchow
|
| Posted: 03/16/2004, 8:07 AM |
|
Hello Everyone!
I went through the application builder and set it to create the app in ASP connecting to a Oracle server. I went through the entire process. Was able to see all the tables, select my tables, etc.. When I finished the project, and click finished and deployed the app this is the error I get.
Error: ORA-00942: table or view does not exist (Microsoft OLE DB Provider for Oracle)
The tables does exist. I accessed it the entire time when I creating the app!
Any thoughts?
Will
|
|
|
 |
William Muenchow
|
| Posted: 03/16/2004, 8:39 AM |
|
Tried all options in the application builder. If this be the case, CSS doesn't work with oracle?
|
|
|
|
peterr
Posts: 5971
|
| Posted: 03/16/2004, 12:48 PM |
|
Hello,
CCS works OK with Oracle.
Keep in mind that connecting to the database is done differently when designing an application than when running the generated ASP programs. The ASP programs use the connection specified in the Connection's Server tab, like shown here:
http://docs.codecharge.com/studio/html/UserGuide/WorkingWithProjs/ug051.png
http://docs.codecharge.com/studio/html/UserGuide/WorkingWithProjs/ug053.png
http://docs.codecharge.com/studio/html/UserGuide/WorkingWithProjs/ug054.png
I'm actually not sure why you're getting this error, therefore possibly you could describe here how is your Server connection setup.
Also make sure that "Oracle" is selected as the database in both the Design and Server connections.
This may also be a problem related to the Oracle itself (drivers, configuration, etc.). Our support may be able to help you further if that's the case.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Dealney
|
| Posted: 05/05/2004, 8:36 AM |
|
WE have the exact same problem . Did you solved it.
Quote Will Muenchow:
Hello Everyone!
I went through the application builder and set it to create the app in ASP connecting to a Oracle server. I went through the entire process. Was able to see all the tables, select my tables, etc.. When I finished the project, and click finished and deployed the app this is the error I get.
Error: ORA-00942: table or view does not exist (Microsoft OLE DB Provider for Oracle)
The tables does exist. I accessed it the entire time when I creating the app!
Any thoughts?
Will
|
|
|
|
|
