vb.net - “OdbcConnection”在 vb.net 互操作应用程序中不明确

Question

我的 VB.NET Windows 窗体应用程序中有以下代码:

Case "DB2"
    Try
        Dim row As DataRow

        Using cnDB2 As New OdbcConnection(source_cnString)
            Dim drDB2 As OdbcDataReader = Nothing
            Dim cmdDB2 As New OdbcCommand(dtSource, cnDB2)

            cnDB2.Open()
            drDB2 = cmdDB2.ExecuteReader

            While drDB2.Read
                row = dsSourceData.Tables(tableName).NewRow()
                Dim iCell As Integer

但我收到一个编译错误:

'OdbcConnection' is ambiguous, imported from the namespaces or types 'Microsoft.Office.Interop.Excel, System.Data.Odbc'

我有这些 进口 在类里:

Imports System.IO
Imports System.Xml
Imports System.Xml.XPath
Imports System.Data.Odbc
Imports System.Data.SqlClient
Imports Microsoft.Office.Interop.Excel
Imports System.Net.Mail
Imports System.Text

Answer 1

如错误输出中所述，OdbcConnection 存在于“Microsoft.Office.Interop.Excel”和“System.Data.Odbc”命名空间中。您必须通过在代码中放置完整的命名空间来指定正在使用的名称。

Using cnDB2 As New System.Data.Odbc.OdbcConnection(source_cnString)