Backup and Restore SQL database with vb.net

[ninel]

I have the following code:

Dim oSQLServer As New SQLDMO.SQLServer
Dim oBackup As New SQLDMO.Backup
Dim oRestore As New SQLDMO.Restore
Dim BACKUPFILE As String
Dim DATABASE As String
BACKUPFILE = "C:\VoicenetSQL\project\tampa\Politic\" & ProjectFolder & "\VoiceNet_TemplateBackup.bkp"
       
DATABASE = "VoiceNet_at0000"
With oBackup
            .Files = BACKUPFILE
            .Database = DATABASE
            .BackupSetName = "VoiceNet"
            .BackupSetDescription = "Backup from VB.NET application"
            .oSQLServer.Connect("NINEL-D246655F1", "timecontroluser", "timecontroluser")
            .SQLBackup(oSQLServer)
        End With
        
        oSQLServer.DisConnect()

This is not working. I am getting the following error:
"Public member 'oSQLServer' on type 'BackupClass' not found."
Does anyone know how to accomplish this?
Thanks,
Ninel

 

[cjard]

have you added a reference to SQLDMO, whatever it is?

 

[vis781]

I assume that because of the error he already has added the reference. More likely to be a typo in the article that that code was pasted in from.
Just a guess, but i think that this line...

.oSQLServer.Connect("NINEL-D246655F1", "timecontroluser", "timecontroluser")

should read..

.SQLServer.Connect("NINEL-D246655F1", "timecontroluser", "timecontroluser")