How to connect to odp.net — oracle-tech

    Forum Stats

  • 3,715,657 Users
  • 2,242,821 Discussions
  • 7,845,481 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

How to connect to odp.net

3689816
3689816 Member Posts: 3
edited April 2018 in ODP.NET

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.

Answers

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 2,751 Employee
    edited April 2018

    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.

This discussion has been closed.