Oracle Developer Tools for Visual Studio. NET Installation and use

Source: Internet
Author: User
Tags mongodb postgresql redis oracle developer
Oracle Developer Tools for Visual Studio .NET

Its main purpose is to achieve seamless development using Oracle DataBase J in Visual Studio.

I have tasted the convenience of accessing Sql Server database in Visual Studio.

After you install Oracle Developer Tools for Visual Studio .NET,

You can also achieve the same convenience of accessing Oracle database as accessing Sql Server data in Visual Studio,

For example, you can implement the debugging of Oracle DataBase development in Visual Studio,

You can also directly access the Oracle database, write stored procedures, or trigger these PL/SQL,

Similarly, you can use database controls such as SqlDataSource to access the Oracle database.

Similarly, you can also manipulate the data in the Oracle database through these operations on the data set.

In short, after you install Oracle Developer Tools for Visual Studio .NET,

You can easily and conveniently access the Oracle database in Visual Studio,

First of all, let’s look at my matching platform.

software platform

 Win7 32-bit Ultimate Edition, Oracle 10.2.0, VS 2012

Download the ODT tool from the official Oracle website:

I downloaded ODAC 11.2 Release 5 ( with Oracle Developer Tools for Visual Studio. I downloaded ODAC 10.2 before, but it only supports VS2005, not 2012. You can download the corresponding installation package according to your VS version . Install after decompression, after completion

Open Visual Studio 2012 again

You can find something more under the "Tools" column of Visual Studio, and then you can select "Connect to Database" under the "Tools" column

If the user name/password is incorrect, please install the following method 3 to solve it, and then restart VS2012.

From the above, we can know that using ODT.NET to connect to the Oracle database is successful

Click "OK" to establish this connection with the Oracle database,

Then you can view it in the "Server Explorer"

Oracle Developer Tools for Visual Studio .NET installation and use

 After installing ODTwithODAC on win7, the problem solving method:

1. It stops when installing ODTwithODAC to about 88%.
      Solution: turn off 360 and anti-virus software, etc.
2. The program does not respond when ODTwithODAC is installed to 100%.
            First delete the C:\Users\Administrator\Oracle folder;

           Then end the omtsreco.exe process and delete the OracleMTSRecoveryService service;

           Finally delete the C:\app folder and C:\Program Files\Oracle folder, and reinstall.
3. After installing ODAC, use PL/SQL to connect to the database and it appears: initialization error could not locate OCI dll.
              Reason: Oracle Client 11g was installed when ODAC was installed. At this time, Oracle's environment variables were modified, and the Oracle home and oci library in PL/SQL were also modified, so the corresponding tnsnames file and oci.dll could not be read.
             Open PL/SQL, enter tools-->preferences, as shown in the following interface. Configure Oracle Home and OCI library. OK!!
             Such as: Oracle Home: OraClient11g_home1
                     OCI library: D:\oracle\product\10.2.0\db_1\bin\oci.dll
4. ORA-12154 appears during pl/SQL connection
              Check whether the tnsnames.ora file is in the Admin directory.
              Check that the C:\app\Administrator\product\11.2.0\client_1\Network\Admin\tnsnames.ora file is configured correctly. For the original text, please refer to:

Alibaba Cloud Hot Products

Elastic Compute Service (ECS) Dedicated Host (DDH) ApsaraDB RDS for MySQL (RDS) ApsaraDB for PolarDB(PolarDB) AnalyticDB for PostgreSQL (ADB for PG)
AnalyticDB for MySQL(ADB for MySQL) Data Transmission Service (DTS) Server Load Balancer (SLB) Global Accelerator (GA) Cloud Enterprise Network (CEN)
Object Storage Service (OSS) Content Delivery Network (CDN) Short Message Service (SMS) Container Service for Kubernetes (ACK) Data Lake Analytics (DLA)

ApsaraDB for Redis (Redis)

ApsaraDB for MongoDB (MongoDB) NAT Gateway VPN Gateway Cloud Firewall
Anti-DDoS Web Application Firewall (WAF) Log Service DataWorks MaxCompute
Elastic MapReduce (EMR) Elasticsearch

Alibaba Cloud Free Trail

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.