Page 1 of 1

Getting feedback from scripts

Posted: Thu 20 Mar 2008 01:09
by bernr
I have a 9000 line T-SQL script that has print statements in it to give status of what it is doing, is there a way I can be able to see these using any of the SDAC Controls? I am currently using the MSScript control to execute the script.

Thanks Bern

Posted: Thu 20 Mar 2008 07:51
by Antaeus
You should handle the OnInfoMessage event of the linked TMSConnection. Also add the OLEDBAccess unit to the uses clause.

Posted: Thu 20 Mar 2008 10:42
by bernr
Thank you for your reply, I have added the OnInfoMessage event to my TMSConnection but it does not seem to be firing. Any suggestions?