[VB.NET]OLEDB.NET 如何访问Oracle8i

来源:互联网 发布:淘宝站外活动平台 编辑:程序博客网 时间:2024/05/18 00:01
VB.NET源码-156个实用实例哦……<script type="text/javascript"><!--google_ad_client = "pub-8333940862668978";/* 728x90, 创建于 08-11-30 */google_ad_slot = "4485230109";google_ad_width = 728;google_ad_height = 90;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
OLEDB.NET 如何访问Oracle8i
Private OraConn As New OleDb.OleDbConnection
Private OraCmd As New OleDb.OleDbCommand

OraConn = New OleDb.OleDbConnection
OraConn.ConnectionString = Provider=MSDAORA.1;user id= & UserID & ;password= & Password & ;data source= & DataSource
OraConn.Open()
OraCmd.Connection = OraConn

为何打不开链接
__________________________________________________________________________
o Standard security:
Provider=msdaora;Data Source=MyOracleDB;User
Id=myUsername;Password=myPassword;
This one s from Microsoft, the following are from Oracle
o Standard Security:
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User
Id=myUsername;Password=myPassword;

o Trusted Connection:
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;
__________________________________________________________________________
哦...这样...恩恩...
__________________________________________________________________________
原创粉丝点击