How to install Oracle prior using dotConnect with Visual Studio

How to install Oracle prior using dotConnect with Visual Studio

Postby maxima120 » Sun 01 May 2016 21:32

I am reinstalling my dev machine. I had Oracle 11G installed (some client tools from complicated Oracle installer ages ago). The guy who knew what to install is gone now.

Are there simple instructions how to install Oracle on client machine to develop using Dotconnect for Oracle with Visual Studio and EF?

(I might need Oracle to run some PLSQL applications like PL/SQL Developer or SQL Plus tool)
maxima120
 
Posts: 11
Joined: Tue 15 Mar 2016 14:19

Re: How to install Oracle prior using dotConnect with Visual Studio

Postby Shalex » Mon 02 May 2016 11:02

Oracle 9.2.0.4 or higher is required for Entity Framework to function properly.

maxima120 wrote:Are there simple instructions how to install Oracle on client machine to develop using Dotconnect for Oracle with Visual Studio and EF?
This question exceeds the goals of our support. Please contact Oracle Support Team. In general, it is enough to launch the installation wizard and follow its steps.
Shalex
Devart Team
 
Posts: 7606
Joined: Thu 14 Aug 2008 12:44

Re: How to install Oracle prior using dotConnect with Visual Studio

Postby maxima120 » Mon 02 May 2016 11:29

I followed dotConnect install and it didn't work in the end (project with EF model in it refused to open).

Devart support should state what dependencies are on the Oracle installation. This is exactly your job. You should know better than anyone how Oracle installation is complicated. There are quite a few installations exist. And each of them have dozens of options.

> Oracle 9.2.0.4 or higher is required

is not the answer. there is a hundred different things can be called Oracle.

For example I am currently looking at this:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html

I understand first 2 zips are for server db install

client is for client machines.. If I run this it has a lots of components. Which one do I have to install in order to satisfy Devart product?
maxima120
 
Posts: 11
Joined: Tue 15 Mar 2016 14:19

Re: How to install Oracle prior using dotConnect with Visual Studio

Postby Shalex » Wed 04 May 2016 08:14

For the base CRUD functionality, it is enough to install Oracle Database Express Edition without Oracle Client, because dotConnect for Oracle Professional includes the Direct mode feature: https://www.devart.com/dotconnect/oracle/docs/?directmode.html.

If you want to use an advanced functionality, you should install the corresponding Oracle edition (https://docs.oracle.com/cd/E11882_01/license.112/e47877/editions.htm#DBLIC116) with the needed feature. For example:
Shalex
Devart Team
 
Posts: 7606
Joined: Thu 14 Aug 2008 12:44

Re: How to install Oracle prior using dotConnect with Visual Studio

Postby maxima120 » Wed 04 May 2016 08:16

Thank you.
maxima120
 
Posts: 11
Joined: Tue 15 Mar 2016 14:19


Return to dotConnect for Oracle