win7 64位系统 vb.net连接oracle问题 急求!!!!!!!
vb.net 2003 运行程序能连接oracle’ 但2005报错 信息“未找到安装程序,该程序可能未正确安装”
plsql都能连接oracle
系统:win7 64位系统
oralce 安装 64位
在目录下面安装instantclient_11_2 32位用于PLSQL连接
环境配置:
1>."Path" , 把 "C:\app\product\instantclient_11_2;" 加入;
2>."新建","TNS_ADMIN", 变量值设置为"C:\app\product\instantclient_11_2;
3>."新建","NLS_LANG", 变量值设置为"SIMPLIFIED CHINESE_CHINA.ZHS16GBK
vs.net 程序连接oracle
Try
If M_CN1.State = 0 Then
M_CN1.ConnectionString = "Provider=MSDAORA.1;User ID=user/password;Data Source=server;Persist Security Info=True"
M_CN1.CursorLocation = ADODB.CursorLocationEnum.adUseClient
M_CN1.CommandTimeout = 10
M_CN1.ConnectionTimeout = 1
M_CN1.Open()
GF_DbConnect = True
End If
Catch ey As Exception
Call Gp_MsgBoxDisplay("服务器链接有错误...!!!", "W", "DataBase Connection")
If Err.Number = 438 Or Err.Number = -2147467259 Then
M_CN1.Close()
End If
GF_DbConnect = False
End Try
不知道为什么,搞了三天了也没弄好!求明白的指导一下,谢谢