
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;
__________________________________________________________________________
哦...这样...恩恩...
__________________________________________________________________________