dbTalk Databases Forums  

Issues with Debugging ActiveX

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Issues with Debugging ActiveX in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
gurumum@email.uc.edu
 
Posts: n/a

Default Issues with Debugging ActiveX - 01-18-2005 , 03:53 PM






Hi,

I've been trying to debug ActiveX scripts that I'm using in my DTS
packages.

I have my DTS packages in SQL2000 . I have MS Visual Studio 6.0 and
InterDev installed on my machine which runs on Win 2000.

I have checked the "Enable just-in time debugging" option.
I have a STOP statement in my activex code.

But during execution, the entire package just gets executed without
stopping at the STOP statement, effectively not letting me debug
ActiveX Scripts.

Is there some settings change to be made in either Visual studio or
somewhere else to get the debugging working?

Based on one of the earlier posts in the group, I downloaded MS Script
Debugger. My package then stops at my STOP sign and lets me step
through the code.
But the code opens in MS Script Debugger which doesnt have the kind of
debugging tools Visual studio offers.

Can anyone help?


Madhusudhan


Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: Issues with Debugging ActiveX - 01-18-2005 , 06:21 PM






In message <1106085185.667796.276420 (AT) c13g2000cwb (DOT) googlegroups.com>,
gurumum (AT) email (DOT) uc.edu writes
Quote:
Hi,

I've been trying to debug ActiveX scripts that I'm using in my DTS
packages.

I have my DTS packages in SQL2000 . I have MS Visual Studio 6.0 and
InterDev installed on my machine which runs on Win 2000.

I have checked the "Enable just-in time debugging" option.
I have a STOP statement in my activex code.

But during execution, the entire package just gets executed without
stopping at the STOP statement, effectively not letting me debug
ActiveX Scripts.

Is there some settings change to be made in either Visual studio or
somewhere else to get the debugging working?

Based on one of the earlier posts in the group, I downloaded MS Script
Debugger. My package then stops at my STOP sign and lets me step
through the code.
But the code opens in MS Script Debugger which doesnt have the kind of
debugging tools Visual studio offers.

Can anyone help?


Madhusudhan

From memory, halt the execution my adding a MsgBox statement. You should
then be able to use VS to attach to the process. Set stop at next line
or similar. Clear the message box and you should be good to go.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.