Utilizing "dotConnect for Oracle Samples - DataReader", everything seems to work via a Direct Connection.
Code: Select all
Open connection: "User Id=testDBadmin;Server=serv08oracle11;Direct=True;Sid=xe;" Taking connection from connection pool: "User Id=testDBadmin;Password=admin;Server=serv08oracle11;Direct=True;Sid=xe" Connection is taken from pool. Pool has 1 connection(s). Prepare: SELECT * FROM Dept Execute: SELECT * FROM Dept Returns: DEPTNO DNAME LOC ----------- ----------- ----------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON
I've search through your site and read every post associated with different combinations of word from the error messages with no success of finding a solution.
I downloaded docConnect Pro (Devart.Data.Oracle version 220.127.116.11). Nuget updated the CrmDemo project to EF 4.4.0.
Additionally, which of the following is correct? Neither combo resolves issue above, but would like to know which is correct:
C:\Program Files (x86)\Common Files\Devart\dotConnect\5.0\Net2\Common\Devart.Data.Oracle.dll & Devart.Data.dll
C:\Program Files (x86)\Devart\dotConnect\Oracle\Devart.Data.Oracle.dll & Devart.Data.dll
Please let me know if have any questions.