Query Oracle from C#/ADO.NET/SQL Server Application
456673Sep 27 2005 — edited Jan 23 2007I 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