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 7.2.114.0). 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
OR
C:\Program Files (x86)\Devart\dotConnect\Oracle\Devart.Data.Oracle.dll & Devart.Data.dll
Please let me know if have any questions.
Respectfully,
David C