Connect Microsoft Visual Studio to Oracle
This topic describes how to connect Microsoft Visual Studio to an Oracle database using the ODBC driver.
Visual Studio is a powerful development environment that provides tools for editing, debugging, and compiling code, as well as creating applications. These applications can connect to databases and services on a local machine, across a network, or in any cloud environment—private, public, or hybrid. To connect Visual Studio to a data source such as Oracle, you can use Devart ODBC driver for Oracle.
Create a DSN for Oracle
Before you start, you need to configure a DSN for Oracle in the ODBC Data Source Administrator. It’s required to establish a connection to an ODBC database in Visual Studio. You can find the instructions for your OS in the following topics:
Connect Visual Studio to Oracle
1. Open Microsoft Visual Studio.
2. Open Server Explorer: On the View menu, select Server Explorer.
3. In Server Explorer, right-click Data Connections and select Add Connection.
4. In the Choose Data Source dialog, select Microsoft ODBC Data Source and click Continue.
5. In the Data source specification section, select your Oracle DSN from the Use user or system data source name dropdown list.
6. Optional: Click Test Connection to verify connectivity.
7. Click OK.
The new connection appears under Data Connections in Server Explorer.
