Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to connect to odp.net

3689816Apr 12 2018 — edited Apr 13 2018

Oracle.ManagedDataAccess.dll

Oracle.ManagedDataAccess.EntityFramework.dll  Connected.

I use the sql gate for oracle, and I would like to connect to the visual studio.

I downloaded all the applicable files.

However, effective - New Connection-Data Source Change does not show odp.net.

I have linked my oracle database to the view - server explorer - data connection. Please give me the solution.

Comments

Alex Keh-Oracle

What is SQL Gate for Oracle?

You need to install an ODAC version with the Oracle Developer Tools for Visual Studio included with it. Here's a video on how to do it with the ODAC for ODT OUI version.

You can also use the MSI install for the Visual Studio version you are using, which is more streamlined.

If you are using Visual Studio Community Edition, you must download the most recent (April, 2018) MSI version as there was a bug in the earlier ODAC version that didn't allow it to work in Community.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 11 2018
Added on Apr 12 2018
1 comment
264 views