Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Other Development Tools
 [SQL-DMO]Code execution exception
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

11 Posts

Posted - 10/06/2004 :  11:48:08  Show Profile  Send iamlerxt an AOL message  Send iamlerxt an ICQ Message  Send iamlerxt a Yahoo! Message  Reply with Quote
I am using SQLDMO backup object in VB6. I am declaring the object WITHEVENTS so I can use the PercentComplete event to update a progress bar. When I execute the SQLBackup method, it creates a legal, restorable backup in the correct location. It also updates the progress bar perfectly. But it raises an error -2147221499 [SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION. I have searched the web for this error and haven't found much info in the context that I need. MSDN offers workaround fixes, but not specifically for the sqldmo backup object.
My frustration has reached the point where I'm actually considering trapping and ignoring the error, since I do have valid backups being generated. Any help would be greatly appreciated.

Ronnie Applewhite

Starting Member

1 Posts

Posted - 10/15/2004 :  03:50:24  Show Profile  Send rsanteza a Yahoo! Message  Reply with Quote
Hi Ronnie,

You should add two sub procedure within your form, for example you use DBBackUp as your SQLDMO object name

' declare SQLDMO Object
Dim WithEvents DBBackUP As SQLDMO.Backup

' then add two procedure below
Private Sub DBBackUP_Complete(ByVal Message As String)
' add message that the backup is completed
End Sub

Private Sub DBBackUP_PercentComplete(ByVal Message As String, ByVal
Percent As Long)
' add message or progress bar
End Sub

I hope this message will help you....

Ronnie Anteza
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000