Hi,
I am facing one problem
I want to restore database in MSDE.
my database is restored but in MSSQL folder instead of MSDE Server.
code is
Dim oSQLServer As SQLDMO.SQLServer = New SQLDMO.SQLServerClass
Dim oRestore As SQLDMO.Restore = New SQLDMO.RestoreClass
path = System.IO.Directory.GetCurrentDirectory
aString = ("[" & path & "\Allfiles\Database\SensorNET_Backup]")
oRestore.Files = aString
oRestore.Database = "SensorNETEx"
oRestore.ReplaceDatabase = True
oSQLServer.Connect("IBM1\SensorNETMSDE", "sa", "")
oRestore.SQLRestore(oSQLServer)
MsgBox("Database is Restored")
can u help me ?
I am facing one problem
I want to restore database in MSDE.
my database is restored but in MSSQL folder instead of MSDE Server.
code is
Dim oSQLServer As SQLDMO.SQLServer = New SQLDMO.SQLServerClass
Dim oRestore As SQLDMO.Restore = New SQLDMO.RestoreClass
path = System.IO.Directory.GetCurrentDirectory
aString = ("[" & path & "\Allfiles\Database\SensorNET_Backup]")
oRestore.Files = aString
oRestore.Database = "SensorNETEx"
oRestore.ReplaceDatabase = True
oSQLServer.Connect("IBM1\SensorNETMSDE", "sa", "")
oRestore.SQLRestore(oSQLServer)
MsgBox("Database is Restored")
can u help me ?