restore a data base

hi
i have created the back up of my database in sql server 2000 but i can restore it.
my teacher gave me the code but it gives the error user defined type not defined
the code is in the attachment can u plz tell me whts wrong with this
i have also added the dll file for sql as instructed by my teacher

You won't need such a big class module for this. I did this long ago, so I'm not sure whether these statements would work correctly or you may need some minor modifications to the SQL statement:

VB Code:

Dim conn As New ADODB.Connection
conn.open "PROVIDER=MSDASQL;Driver=SQL Server;Server=YourServerName;Database=master;UID=sa;PWD=Yourpassword;"
conn.Execute "use master;Restore Database YourDBName from YourDBBackupFile;"
conn.Close
set conn = Nothing

Hope this helps :wave:

You need to add a reference to the Microsoft SQLDMO Object Library to your project.

Quote:

---

Originally Posted by brucevde

You need to add a reference to the Microsoft SQLDMO Object Library to your project.

---

thanx for ur reply but i have added a .dll file into my project folder
how can i add a reference
:confused:

Project|References|Browse