im struggling to debug from an activex dll in vb6. the is called from vba code within excel.
i set the debugging > start programs to excel and this all works fine.
if i place a break point in my vb6..once vba calls reference to that part of the vb6, i hit the break point and all is great.
However, for some strange reason why i call a stored procedure during debugging in this method..i get the following error:
run-time error '-2147217871 (80040e31)': timeout expired
if i step through my code, the stored procedure is called and i have data correctly returned but if i try to manually run a sql query..SQL just hangs.
this process is causing my dll to fail once attempts to run a 2nd stored procedure..(see error message above).
i've unregistered the dll before running my activex dll to see if that made a difference - no change.
However, if i make the dll and reference it via excel etc...the DLL / SQL do what i expect and i have no problems.
any ideas what is causing this? i want to add additional functionality into my dll and i need to debug.
tools: VB6, VBA, Excel 2003, SQL 2000