Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query Oracle from C#/ADO.NET/SQL Server Application

456673Sep 27 2005 — edited Jan 23 2007
I am in the process of qualifying our C# application using ADO.NET and SQL Server database to work against an Oracle database. I used SQL Server's DTS to create the schema in Oracle from the SQL Server database. I then edited the connection string stuff to point to the Oracle database, but I get the Oracle error ORA-00942 (table or view does not exist). By changing the embedded SQL from "select * from tTableName order by icolumnname" to "select * from \"tTableName\" order by icolumnname" (simply adding double quotes around the table name), the query works fine. I've also tried this in the application Toad and get the same results. I'm logging in as the SYSTEM user. I think my problem has to with privileges/roles/permissions, but I'm not sure exactly what to do here. My background is that i've used SQL Server for about 8 years and I used Oracle a little about 6 years ago. So I do know a little about Oracle (but not enough).

Any help would be appreciated
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2007
Added on Sep 27 2005
12 comments
2,302 views