Oct 24, 2016 02:25 PM|Richard Scannell|LINK
When I connect to an Oracle 11 database using Oracle.DataAccess (v 4.0.30319 ) a simple query (Select * from DifferentSchema.myView) returns about 300 rows with the C# code below:
OracleConnection conn = new OracleConnection();
conn.ConnectionString = "User Id=myUserid;Password=myPass;Data Source=myConnectionStr;";
String OraSql = "Select TO_CHAR(Employee_Number) from APPS.myView";
// String OraSql = "SELECT TO_CHAR (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') FROM DUAL";
OracleCommand cmd = new OracleCommand(OraSql, conn);
OracleDataReader dr = cmd.ExecuteReader();
When I change it to be with OracleManagedDataAccess (v4.0.30319), then the query
appears to run, because there is no Ora-nnnn exception code, BUT the data reader results view is empty. 'Enumeration yielded no results"
What else can I try to make this work?
( FYI I am looking at Oracle Managed Data Access - because a UAT deployment to a 2012 server is having issues with the installation of an Oracle client )