ODBC doesn't gives you any database manipulation tools (not the data, the database itself). You have to rely to your engine tools. For example, MS SQL Server gives you SQL-DMO to create functionalities through VB code to manipulate the database. Have a look at the DB2 documentation to know if they give you an object to include to your VB app to manipulate the database.


>I have developed a package in vb6 and database is in DB2-7. But I am unable to take a backup of the database from the VB6 code and I also want to restore the backup. Please help me if you know the answer. The database is connected using ODBC and on a server.