下面是我的环境:
64位操作系统,基于x64的处理器Windows10 Enterprise Visual Studio2010 Oracle客户端64 11gR2 ODAC 64k ODAC 32k
问题是我无法让Visual Studio 2010连接到Oracle 11g数据库。
从Oracle Client 64 11gR2、ODAC 64k和ODAC32k尝试Oracle.DataAccess.DLL,没有成功。
我也尝试将.NET框架设置为4和2,但没有成功。
我也尝试过System.Data.OracleClient,它报告32位和64位冲突
任何帮助都将不胜感激。
谢谢
导入Oracle.DataAccess.Client分部类_Default继承System.Web.UI.Page
Protected Sub Button1_Click(sender As Object, e As System.EventArgs) Handles Button1.Click
Dim oradb As String = "Data Source=CustomerDB;User ID=userid;Password=password"
Dim conn As New Oracle.DataAccess.Client.OracleConnection(oradb)
Response.Write(conn.Database.ToString())
Response.Write(conn.State.ToString)
conn.Open()
Dim sql As String = "select name from customer where CustID=1"
Dim cmd As New Oracle.DataAccess.Client.OracleCommand(sql, conn)
Dim dr As Oracle.DataAccess.Client.OracleDataReader = cmd.ExecuteReader()
dr.Read()
Response.Write(dr.Item("name"))
conn.Close()
conn.Dispose()
End Sub
结束类
发布于 2016-06-28 04:46:14
Visual Studio本身不是64位的。您需要安装32位组件才能将Visual Studio连接到Oracle。
https://stackoverflow.com/questions/38067158
复制相似问题