Re: Return all InfoMessages

From: Steve (morriszone_at_hotmail.com)
Date: 03/18/05 

Date: 18 Mar 2005 07:14:47 -0800

The InfoMessage event is also part of ADO classic and has been for
serveral versions. I built an Access XP front end for some
administrative tasks for a SQL Server 2000/W2003 database.

Private Sub cnnReport_InfoMessage(ByVal pError As ADODB.Error, adStatus
As ADODB.EventStatusEnum, ByVal pConnection As ADODB.Connection)
    On Error Resume Next
    Dim strMessage As Variant
    Dim obj As ADODB.Error
    For Each obj In pConnection.Errors
        strMessage = strMessage & obj & vbCrLf
    Next obj
    MsgBox strMessage
End Sub

Relevant Pages

  • Inet -> Winsock : Must close server for reply
    ... Inet control to connect in HTTP to the server which is actually not a ... Private Sub Winsock1_ConnectionRequest ... Dim sCommand As String ...
    (microsoft.public.vb.general.discussion)
  • Inet -> Winsock : Must close server for reply
    ... Inet control to connect in HTTP to the server which is actually not a ... Private Sub Winsock1_ConnectionRequest ... Dim sCommand As String ...
    (microsoft.public.vb.winapi)
  • [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction context in use by another session.
    ... SQL Server Version: ... Set local variables to nothing ... Private sub FetchChildOptions ... Both of the methods are in the same class using same transaction ...
    (microsoft.public.sqlserver.programming)
  • Re: Client Connection
    ... > This will post the page to the server every 10 seconds. ... > Private Sub Page_Load(ByVal sender As System.Object, ... > Thank you, Mike Moore ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Big problems with data binding
    ... I am updating not inserting and the update command does not update the ... as far as the server is concerned. ... If the user changes a value in a text box how does that value get ... > Private Sub Button1_Click(ByVal sender As System.Object, ...
    (microsoft.public.dotnet.framework.aspnet)