How to connect to — oracle-tech

    Forum Stats

  • 3,715,657 Users
  • 2,242,821 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

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


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

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


  • 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.