UserConnection, Qry debug, RemoteAutomation 
Author Message
 UserConnection, Qry debug, RemoteAutomation

I am using VB5.0 for a 32-bit client/server app connecting to SQLServer 6.5
via 32-bit ODBC.  I have am able to use the Visual Database Tool (Developer
Studio) to create and test the stored procedure.

I am using a UserConnection object to run the stored procedures within the
VB app.  I can succesfully run some of the stored procedures using the
UserConnection.  Therefore, I know I am connecting correctly to the
database.  However, I created a new procedure today and went to debug it
from the UserConnection (by right clcking on the query within VB and chosing
debug procedure).  Now I get the following error messages:

"The query could not be debugged due to a problem coordinating events with
the server.  Check the server and client log to find the exact cause, fix
the problem and try again."

Strangely, I am able to run the stored procedure using T-SQL de{*filter*}, but I
get that silly message when I try debugging it from the UserConnection qry.

Also, can someone explain why Automation Manager is running on my client and
the server?  I thought this was for 16-bit compatibility?

Tue, 06 Mar 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. UserConnection, Qry debug, RemoteAutomation

2. inserting the result of qry into a table through vba

3. Combo Box from qry

4. ODBC Pass-Thru Qry in VBA

5. single field to multiple field update qry

6. coding for an update qry.

7. Qry re Source Safe to overcome Speed Ferret problem

8. Newbie: Passing Parameters to a passthrough qry pt 2

9. Multiple param qry through combo

10. Transaction Error: ODBC time out when executing action qry w/ hetero joins

11. Append Qry In Access 2000

12. QRY Automatically entering hyperlinks


Powered by phpBB® Forum Software