Compass

导航

 

VS2012+MVC3+ORACLE_11g_R2+ODAC_11G_R5

 

Environment:

Win 7 X32

JDK 1.8

ORACLE 11G_R2

PLSQL9

VS2012 X86

ODAC_11g_Release5 (32bit)

 

Software LIST:

 

 

Process:

1.JDK 1.8

(1)

 

(2)

 

2.Oracle11gR2

 

(1)

 

(2)

 

(3)

 

(4)

 

(5)

 

(6)

 

(7)

 

(8)

 

(9) Scott Edit PWD

 

(10) success

 

 

3.plsqldev9

(1)

 

(2)

 

 

Note: configure and test

 

 

TNS_ADMIN=C:\app\COMPASS\product\11.2.0\dbhome_1\NETWORK\ADMIN; //the location of tnsnames.ora

 

NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK;  //the language of your oracle system and system

 

SQL DEVELOPER and PLSQL  TEST

(1)SQL DEVELOPER TEST

 

 

 

 

 

 

 

(2) PLSQL TEST

 

 

 

 

 

4.VS2012

Default

 

5.ODAC_11G_RELASE5

(1)

 

(2)

 

 

 

6. the last test

(1)

 

(2)

(3)

 

(4)

 

(5)

 

 

 

 

Note:

Some errors,you can restart the services about oracle

 

Usual cmd:

tnsping orcl

regedit

services.msc

lsnrctl start

 

posted on 2014-07-22 15:00  chinazhoumin  阅读(1201)  评论(6编辑  收藏  举报