問(wèn)題描述
我得到了一些 vba 代碼來(lái)支持使用以下語(yǔ)法連接到 Oracle 數(shù)據(jù)庫(kù):
I have been given some vba code to support that connects to an Oracle database using the following syntax:
Dim m_dbConn As New ADODB.Connection
With m_dbConn
.ConnectionString = "DRIVER={Oracle in oraI3CL_32};dbq=DWGBP1;Uid=;Pwd=;"
.Properties("Prompt") = adPromptAlways
.CursorLocation = adUseServer
.Mode = adModeRead
.IsolationLevel = adXactIsolated
.CommandTimeout = 120
.Open
End With
通常我們會(huì)使用 ODP.net 進(jìn)行連接，所以我不熟悉這種語(yǔ)法，并且任何 oraI3CL_32 的谷歌搜索都不會(huì)返回任何結(jié)果.請(qǐng)有人解釋一下oraI3CL_32是什么，oraI3CL_32中的Oracle"的語(yǔ)法是什么意思，以及以上是否依賴于系統(tǒng)上預(yù)裝了Oracle Data Provider/tnsnames.ora?對(duì)使用 ADO 和 ODP.net 連接(以及 EZConnect 適合所有這些)之間的區(qū)別的任何澄清也將不勝感激.
Normally we would use ODP.net to connect so this syntax is unfamilar to me, and any googling of oraI3CL_32 returns no results. Please can someone explain what oraI3CL_32 is, what the syntax "Oracle in oraI3CL_32" means, and whether the above relies upon having the Oracle Data Provider / tnsnames.ora preinstalled on the system? Any clarification of the difference between using ADO and ODP.net to connect (and where EZConnect fits in all this) would also be greatly appreciated.
推薦答案
您的連接字符串看起來(lái)更像是 ODBC 連接.
You connection string looks more like an ODBC connection.
為了使用 ADODB.Connection，您的連接字符串應(yīng)如下所示:Provider=OraOLEDB.Oracle;Data Source=DWGBP1;User Id=myUsername;Password=myPassword
In order to use a ADODB.Connection your connection string should look like this one:
Provider=OraOLEDB.Oracle;Data Source=DWGBP1;User Id=myUsername;Password=myPassword
在此處查看其他示例:OLE DB 提供程序
或這里 Oracle 連接字符串
這篇關(guān)于使用 ADO 連接到 Oracle的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！