ADO.NET如何和ORACLE数据库连接?

[wsansan]

ADO.NET如何和ORACLE数据库连接?
和Access连接可以如下,
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0" & _
";Data Source=" & Server.MapPath("Sample.mdb")
而和ORACLE连接呢?

[karma]

OLE DB Provider for Oracle (from Microsoft)

oConn.Open "Provider=msdaora;" & _
"Data Source=MyOracleDB;" & _
"User Id=myUsername;" & _
"Password=myPassword;"


OLE DB Provider for Oracle (from Oracle)

For Standard Security:

oConn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User Id=myUsername;" & _
"Password=myPassword;"
For a Trusted Connection:

oConn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User Id=/;" & _
"Password=;"
' Or
oConn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"OSAuthent=1;"

Note: "Data Source=" must be set to the appropriate Net8 name which
is known to the naming method in use. For example, for Local Naming,
it is the alias in the tnsnames.ora file; for Oracle Names, it is the Net8 Service Name.


read more at:
http://www.able-consulting.com/ado_conn.htm?f=ado_conn.htm#OLEDBProviderForOracleFromMicrosoft