Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-01 : 17:50:26
|
Kevin writes "I am trying to backup a SQL Server 6.5 database using SQL DMO using VBA in Access 97, SR-2. As I understand, I can only connect to and perform a backup operation with a SQLOLE object, as opposed to a SQLDMO object for SQL 7.0. (I also understand they are based on the same thing, SQL DMO, except they implement it differently.)
My question is, how can I generate progress events, i.e., how can I use the SQLOLE callback functions or SQL Server 6.5 itself to know and update how far along a backup is in a percentage-based display? This is simple with a SQLDMO object because it uses events, but the SQLOLE implementation is puzzling.
Thanks,
kev3232"
|
|
|
|
|
|
A Progress bar using SQLOLE