Visual Studio 2013 connects Oracle 11g

1, install Visual Studio 2013, recommend the following URL, download the ISO image, all the way next, not installed on the C drive (online installation total failure ...) ）

2, the Oracle database (i installed the Oracle 11g, the installation will follow the default always next), the default path should be this

After installation, remember to unlock Scott account, Scott account is the Oracle database comes with a regular user, specifically can Baidu get

Server name Settings ORCL

3. Download odac:http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

Because the VS 2013 version does not support the connection of Oracle, you need to download the ODAC component Connection Oracle (I heard that the 32bit system is more suitable, I Ann is 32 bit, although the system is 64-bit)

Unzip to a folder, point Setup.exe

The default path should be the red box, Dbhome_1 is the default installation path for Oracle 11g above

4, configuration Tnsnames.ora, is to connect Oracle configuration document

This document is available in the following directory where Oracle is installed

ORCL ==1521== = ORCL) ))

ORCL: Server name

Protocol:tcp

HOST: Is your server IP address, my Oracle is local, wrote localhost

port:1521

Service_name=orcl

5. In Visual Studio 2013, open View--server resource management--data connection, right--add connection

Server name: ORCL

User name:

Password:

Http://www.cnblogs.com/gisdream/archive/2012/05/19/2508993.html

Http://jingyan.baidu.com/article/e4511cf336ce872b845eafd4.html

Http://jingyan.baidu.com/article/1876c852b9049d890b137622.html

Visual Studio 2013 connects Oracle 11g