求ado.net连接oracle数据库
连接串是这样写的,连接不成功,求解
VB.NET code
Dim myconnection As OracleConnection
'Dim strsql = "Driver={Oracle in OraHome90};Server=orcltest;Password=card;User ID=card;Data Source=test_Esa_Web_Opr_Orcl" 'OK 测试大机
Dim strsql = "data source=192.168.1.10;database=test_Esa_Web_Opr_Orcl;User ID=card;pwd=card"
myconnection = New OracleConnection(strsql)
------解决方案--------------------Dim myconnection As OracleConnection
Dim strsql = "server=test_Esa_Web_Opr_Orcl;User ID=card;pwd=card"
myconnection = New OracleConnection(strsql)
其中server 是你oracle 服务名
------解决方案--------------------provider=msdaora.1;User Id=test;password=pass;data source=orcl
orcl是本地net名,配置为连接指定的服务器
test是用户名