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:
http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html
I downloaded ODAC 11.2 Release 5 (11.2.0.3.20) 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%.
Solution:
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.
Solution:
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
Solution:
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: http://www.cnblogs.com/BoyXiao/archive/2010/03/21/1691010.html
http://blog.csdn.net/jiangdragon/article/details/8181971
