Infomessage in ADO Connection

From: Per-Eric Jenshagen (per-eric.jenshagen_at_flintab.com)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 14:22:22 +0200

I am trying to use the OnInfomessage event for TADOConnection to catch
messages (like PRINT 'xxx') coming from stored procedures in SQL-Server.
I am using SQLOLEDB and the connections CursorLocation is set to
clUseServer.

I have no problem catching the first message produced but the other ones I
never see.
I have tried to examine the Errors collection but only one message is there.

Has anyone any idea what to do.

Per-Eric

Relevant Pages

  • Re: SQL Problem
    ... My Access db is distributed to one user for input and about a dozen users ... I should bone up on stored procedures. ... >>Did I mention that my Access query includes queries, ... > as stored procedures in SQL-Server. ...
    (microsoft.public.dotnet.general)
  • Re: Insert into Sonderzeichen
    ... Verwende Stored Procedures und erfreue Dich an dem vom ... dass das ganze nur mit einem SQL-Server funktioniert. ... Solltest Du aber eine ACCESS DB verwenden, ...
    (microsoft.public.de.german.entwickler.dotnet.vb)
  • Re: Odbc connections and ADP?
    ... If you don't want to use ADO, then there is the possibility of setting up ... the connection to the Oracle Server directly on the SQL-Server and perform ... your queries to Oracle from stored procedures. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Stored Procedure
    ... Regards, ... Microsoft Access MVP ... > What is the proper method for executing a SQL-Server ...
    (microsoft.public.access.forms)