[AccessD] ADO Stored Procedure Call

Why are you trying to close the connection before the sp completes?
That doesn't seem logical to me, and I don't see how the procedure could
continue to run if you pulled the plug on the connection that powers it.


You can always open other connections for other activities.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert L.
Stewart
Sent: Wednesday, December 06, 2006 1:02 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] ADO Stored Procedure Call

Well, that works and does not work.

It kills the stored procedure if we close the connection.

Any one with any ideas?


At 12:00 PM 12/6/2006, you wrote:
>Date: Tue, 05 Dec 2006 14:01:30 -0600
>From: "Robert L. Stewart" <rl_stewart at highstream.net>
>Subject: Re: [AccessD] ADO Stored Procedure Call
>To: accessd at databaseadvisors.com
>Message-ID: <200612052005.kB5K5Kq20980 at databaseadvisors.com>
>Content-Type: text/plain; charset="us-ascii"; format=flowed
>
>No, we are running through terminal services and to different
databases.
>It has to go through ADO.  I think I found it, but waiting on the boss 
>to do the testing.  Asynchronous mode on the connection open in ADO is 
>supposed to allow you to close the connection and the procedure to 
>continue to run.
>
>At 12:00 PM 12/5/2006, you wrote:
> >Message: 3
> >Date: Tue, 5 Dec 2006 06:41:52 -0800 (PST)
> >From: Lonnie Johnson <prodevmg at yahoo.com>
> >Subject: Re: [AccessD] ADO Stored Procedure Call
> >To: Access Developers discussion and problem solving
> >         <accessd at databaseadvisors.com>
> >Message-ID: <20061205144152.19599.qmail at web33103.mail.mud.yahoo.com>
> >Content-Type: text/plain; charset=ascii
> >
> >I know this sounds simple but could you call your stored proc via a 
> >passthough query in your code?
> >


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com