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