VB.NET下如何访问ORACLE数据库

[zw19791220]

请问一下在VB.NET下如何访问ORACLE数据库,
是不是需要导入什么包,请哪位朋友帮帮忙.

[小李木耳]

1、首先在Web.config文件中定义类似如下：

<appSettings>
<add key="Provider" value="MSDAORA.1"/>
<add key="PersistSecurityInfo" value="False"/>
<add key="UserID" value="····"/>
<add key="Password" value="····"/>
<add key="DataSource" value="····"/>
<add key="ExtendedProperties" value=""/>

</appSettings>

2、之后程序中调用：

Dim dbConnect As OleDbConnection '连接变量
Dim strTemp As String
Dim odcTemp As OleDbConnection 'DB连接用Connection変数
Dim strDBConStr As String 'DB连接用文字列

'DB连接用文字列
strDBConStr = "Provider=" & config.AppSettings("Provider")
strDBConStr = strDBConStr & ";Persist Security Info=" & _
config.AppSettings("PersistSecurityInfo")
strDBConStr = strDBConStr & ";User ID=" & _
config.AppSettings("UserID")
strDBConStr = strDBConStr & ";Password=" & _
config.AppSettings("Password")
strDBConStr = strDBConStr & ";Data Source=" & _
config.AppSettings("DataSource")
strDBConStr = strDBConStr & ";Extended Properties=" & _
config.AppSettings("ExtendedProperties")

'DB连接
odcTemp = New OleDbConnection(strDBConStr)
odcTemp.Open()