oracle .net 的数据连接
标准流程,参考: http://www.cnblogs.com/wang_yb/archive/2011/07/11/2103368.html
1.安装client
2. 环境变量的设置
设置Windows的环境变量:(我的电脑,右键,属性)
ORACLE_HOME :ODAC的安装目录(类似 ~\app\Administrator\product\11.1.0\client_1)
LD_LIBRARY_PATH :%ORACLE_HOME%
TNS_ADMIN : :%ORACLE_HOME%
3. 监听文件tnsnames.ora的配置, orcale 不像SQL那样可以自动找到服务器
在目录%ORACLE_HOME%\network\admin 下新建文件tnsnames.ora,内容如下:
# TNSNames.ora sample entry
#
# alias =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = myserver.mycompany.com)(PORT = 1521))
# (CONNECT_DATA =
# (SERVER = DEDICATED)
# (SERVICE_NAME = orcl)
# )
# )
#
yutest =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost )(PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
4.vs2010 连接数据库:
数据源名称填写上面的别名: yutest ,用户名/密码按需要填写
参考:
ORACLE官方 :
Build a .NET Application on the Oracle Database with Microsoft Visual Studio 2010
http://www.oracle.com/technetwork/articles/dotnet/vs2010-oracle-dev-410461.html
更高级的XCOPY部署用法请看:http://www.cnblogs.com/nnhy/archive/2011/10/30/2229444.html
oracle应该也有XCOPY方案,用的少,就不研究了
本文来自博客园,作者:James-yu,转载请注明原文链接:https://www.cnblogs.com/james-yu/archive/2012/10/05/2712601.html