'filename' is ambiguous in the namespace. please help me.

[jthan03]

Hi guys,

I'm having problems with this error

'filename' is ambiguous in the namespace 'Microsoft.SqlServer.Management.Smo'
Here's the code:

    Private Sub cmdBkup_Click( _
        ByVal sender As System.Object, _
        ByVal e As System.EventArgs) Handles cmdBkup.Click


        'Dim sqlServer As New SQLServer


        Dim cdDrives As IO.DriveInfo() = IO.DriveInfo.GetDrives
        Dim dirPath As String
        Dim directoryFile As String
        Dim connectionString As String = "Data Source=" & gSqlSvrEnv.SERVER & ";Initial Catalog=" & gSqlSvrEnv.DATABASE & ";Integrated Security = true;"
        Try
            'ﾏｳｽｶｰｿﾙ待機状態
            Cursor.Current = Cursors.WaitCursor


            'ﾎﾞﾀﾝ無効化
            cmdBkup.Enabled = False


            If getSchemaName(connectionString) = "comicbuster" Then
                Call changeSchema(connectionString)
            End If


            ' コントロールの初期化
            lblCpForm.Text = "バックアップ中..."
            lblCpForm.Refresh()
            ProgressBar1.Value = 0


            '管理者でSQLServerに接続
            sqlServer = New Server(gSqlSvrEnv.SERVER)
            sqlServer.ConnectionContext.Connect()
            'POSデータベースをバックアップ
            'Me.lblCpBackupFile.Text = System.IO.Path.Combine(gSystemEnv.DB_BACKUP_PATH, _
            '                    "pos_db_" & DateTime.Now.ToString("yyyyMMdd") & ".dmp")
            Me.lblCpBackupFile.Text = System.IO.Path.Combine(gSystemEnv.DB_BACKUP_PATH, _
                                "pos_db.dmp")


            sqlBackup = New Backup
            With sqlBackup
                '.Action = SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database
                .Action = BackupActionType.Database
                .Database = gSqlSvrEnv.DATABASE
                .BackupSetName = "pos-Full Database Backup"
                'Dim backupDevice As BackupDeviceItem = New BackupDeviceItem(lblCpBackupFile.Text, DeviceType.File)
                '.Files = "[" & Me.lblCpBackupFile.Text & "]"
                .Devices.AddDevice(lblCpBackupFile.Text, DeviceType.File)
                .SqlBackup(sqlServer)
            End With


            Call Zip(lblCpBackupFile.Text)


        Catch ex As Exception
            Call fncErrMsg(MOD_ID & ":" & "cmdBkup_Click()", ex.Message)
        Finally
            'Call fncDBCloseAdmin(sqlServer)
            sqlServer.ConnectionContext.Disconnect()
            sqlServer = Nothing
            'ﾎﾞﾀﾝ表示切替
            cmdBkup.Visible = False
            cmdClose.Visible = True
            Me.ActiveControl = Me.cmdClose
            Call cmdClose.PerformClick()


        End Try


    End Sub


    '===================================================================
    '　処理概要　　：ﾊﾞｯｸｱｯﾌﾟ処理状況表示処理
    '　パラメータ　：規定
    '　戻り値　　　：なし
    '===================================================================
    Private Sub sqlBackup_PercentComplete(ByVal sender As Object, ByVal e As Microsoft.SqlServer.Management.Smo.PercentCompleteEventArgs) Handles sqlBackup.PercentComplete


        Try
            ' 処理経過を表示
            percent = percent + sqlBackup.PercentCompleteNotification
            ProgressBar1.Value = percent
            If percent = 100 Then
                ' 終了メッセージを表示
                lblCpForm.Text = "バックアップ完了"
                System.Threading.Thread.Sleep(1000)
            Else
                System.Threading.Thread.Sleep(100)
            End If


            System.Windows.Forms.Application.DoEvents()


            'ﾏｳｽｶｰｿﾙ待機状態
            Cursor.Current = Cursors.WaitCursor


        Catch ex As Exception
            Call fncErrMsg(MOD_ID & ":" & "sqlDmoBackup_PercentComplete()", ex.Message)
        Finally
        End Try
    End Sub

I already imported the sqlserver references but it still don't work.
Thanks for the help.

 

[jmcilhinney]

I don't see 'filename' anywhere in your code. Does the error point to a particular line?

 

[jthan03]

I don't see 'filename' anywhere in your code. Does the error point to a particular line?

sorry for entering the wrong filename...
i will bold the font of the name with error:

sqlBackup = New Backup

With sqlBackup
'.Action = SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database
.Action = BackupActionType.Database
.Database = gSqlSvrEnv.DATABASE
.BackupSetName = "pos-Full Database Backup"
'Dim backupDevice As BackupDeviceItem = New BackupDeviceItem(lblCpBackupFile.Text, DeviceType.File)
'.Files = "[" & Me.lblCpBackupFile.Text & "]"
.Devices.AddDevice(lblCpBackupFile.Text, DeviceType.File)
.SqlBackup(sqlServer)
End With

[COLOR=#006699 !important]PrivateSubsqlBackup_PercentComplete(ByValsender AsObject, ByVale AsMicrosoft.SqlServer.Management.Smo.PercentCompleteEventArgs) HandlessqlBackup.PercentComplete

Hope for your reply...
Thank you...​

​

 

[JohnH]

The error means compiler can't tell which type you are referring to, for example unqualified "sqlBackup = New Backup" when there is multiple Backup types available from current scope. I'm not specifically aware of any other Backup classes than the Smo.Backup class, but perhaps you have referenced/imported another library that has a Backup class, or perhaps declared a Backup class in your current project.

 

[jthan03]

thanks for the reply...
i will check my codes for revisions...