how to new connection add using oracle database ?

Anjali Khan

hi frnds

I've working on visual studio 2013 and tried to setup Entity framework to access an oracle database.

I click on new ADO.NET entity model, then Generate from database, but on the data connection screen when I click "New Connection" I don't get oracle appearing the list of datasources. I only get two SQL server options.

Do I need to install something extra to get this to work?

why it doesn't work in 2013.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava9y ago
Go on msdn site.
https://msdn.microsoft.com/en-us/library/92ceczx1(v=vs.85).aspx
Nitin Sontakke9y ago
As I suggested before, please resolve connectivity issues from OUTSIDE of Visual Studio. Because we don't know how Visual Studio tries to connect.
Amit Kumar9y ago
Hi Dear,
Follow the below link..

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/dotnet/GettingStartedNETVersion/GettingStartedNETVersion.htm

http://www.oracle.com/technetwork/articles/dotnet/vs2010-oracle-dev-410461.html

https://www.safaribooksonline.com/library/view/adonet-cookbook/0596004397/ch01s10.html
Anjali Khan9y ago
Hi Nitin
when I connected oracle data base from to server explorer tht time from to data source showing oracle data base and connect it to then showing server name and uid pwd. I gave but not connected .
Nitin Sontakke9y ago
If there is something like "New OleDB Entity model" then you should select that one.

Furthermore, you should already have Oracle client installed (I think). Please try all connectivity related things outside Visual Studio, for example, SQL*Plus, etc.