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; "