Link to home
Start Free TrialLog in
Avatar of JonGartzia
JonGartzia

asked on

Exiting VB execution with an error.

 Hello everybody,

  We've got an SQL-Server's job executing an VB 6.0 exe. We want to know whether this execution
failed or not. We've tried using Err.Raise or Stop but execution never ends (executing from this
SQL-Server 2000 job). Could anybody help?

  Thanks in advance,

  Jon
Avatar of EDDYKT
EDDYKT
Flag of Canada image

Have you set the time out value

ie

set cn = Server.CreateObject("ADODB.Connection")
cn.CommandTimeout = 60
cn.open sConnString
ASKER CERTIFIED SOLUTION
Avatar of Mike Tomlinson
Mike Tomlinson
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of JonGartzia
JonGartzia

ASKER

Thank you very much, Idle Mind. It works.
I was looking for something very similar and this was just the job Idle Mind. Thanks.

Mike