Capture SQL Print Ouput

[rrocket]

I have a bunch of print statements in a SP that tell me exactly what went wrong in the SP (if anything), but I cannot figure out how to capture the text in the

PRINT 'Receiver and Customer don''t match'

statements...

I pretty much want to get the info with the SP is executed, store them in a string and show the in a message box.

Is it even possible in VB6? I know you can do it with the .NET stuff, but cannot find any info on doing it in VB6.

[debasisdas]

What exactly you are trying to do ?

[QVeen72]

Hi,

Declare Events for the Connection:
Write this at FormLevel :

Dim WithEvents MyMsg As ADODB.Connection

'and collect the Events in event:
Private Sub MyMsg_InfoMessage(ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pConnection As ADODB.Connection)

MsgBox pError.Description

End Sub

I have not used, but it is done this way only..

Regards
Veena

[rrocket]

Thanks for the suggestion. I actually found this http://support.microsoft.com/kb/294178, but never got everything to work correctly. We actually are switching to output params so life will get much easier (IMO) by doing it that way instead of messing with the print statements.