参考资料:http://www.cnblogs.com/yjmyzz/archive/2011/04/19/2020793.html
< DbProviderFactories > < add name = "Oracle Data Provider for .NET" invariant = "Oracle.DataAccess.Client" description = "Oracle Data Provider for .NET" type = "Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=2.111.7.20, Culture=neutral, PublicKeyToken=89b483f429c47342" /> </ DbProviderFactories > |
1 2 3 | < DbProviderFactories > < add name = "Oracle Data Provider for .NET" invariant = "Oracle.DataAccess.Client" description = "Oracle Data Provider for .NET" type = "Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" /> </ DbProviderFactories > |
Copyright (c) Microsoft Corporation. All rights reserved.
Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArchitecture=AMD64
Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArchitecture=x86
Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArchitecture=AMD64
Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArchitecture=x86
表明你的机器上安装了4个版本的Oracle.DataAccess,分别对应于.net 2.0以及.net 4.0的32位/64位版本
E:\software\oracle11g\ODP.Net\x64>install.bat all c:\odp.net myhome (install all components)
上述命令将自动把所有文件复制到c:\odp.net下
c:\odp.net>configure.bat all myhome (configure all component)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 | using System; using Oracle.DataAccess.Client; namespace test { class Program { static void Main( string [] args) { //建议用这种风格的连接字符串,可以不用依赖于listener.ora文件中的配置 string _connString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));User Id=scott;Password=tiger;" ; using (OracleConnection conn = new OracleConnection(_connString)) { string sql = "select * from emp t where mgr=:mgr" ; OracleCommand cmd = new OracleCommand(sql, conn); conn.Open(); cmd.Parameters.Add( new OracleParameter() { ParameterName= "mgr" ,Value= "7839" }); OracleDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Console.WriteLine( "empno:{0},ename:{1},mgr:{2}" , dr[ "empno" ], dr[ "ename" ],dr[ "mgr" ]); } dr.Close(); } Console.Read(); } } } |
出处:http://yjmyzz.cnblogs.com
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。