 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / SQL Server / ADP / December 2003How to stop AC2002 ADP
AC 2002 is doing a lot of EXEC sp_MShelpcolumns N'ExternalOrderNumbers', NULL, N'id', 1 before each Excute MySP. it there a way to defeat this? AC2000 does not do this. What I really want is a way to send a Execute as a pass thru. can this be done using currentproject.execute ? BF> What I really want is a way to send a Execute as a BF> pass thru. can BF> this be done using BF> currentproject.execute ? Yes. Vadim ---------------------------------------- Vadim Rapp Consulting SQL, Access, VB Solutions 847-685-9073 www.vadimrapp.com BF> What I really want is a way to send a Execute as a pass thru. BF> can this be done using currentproject.execute ? currentproject.connection.execute <sql> Vadim ---------------------------------------- Vadim Rapp Consulting SQL, Access, VB Solutions 847-685-9073 www.vadimrapp.com I use currentproject.connection.execute "MySToredProceedure" or set rs =currentproject.connection.execute( "MySToredProceedure" ) and the profiler shows all the EXEC sp_MShelpcolumns N'ExternalOrderNumbers', NULL, N'id', 1 for each table of MySToredProceedure. What I want is to stop this extra traffic. just a simple send the MySToredProceedure and get back a recordset. > BF> What I really want is a way to send a Execute as a pass thru. > BF> can this be done using currentproject.execute ? [quoted text clipped - 8 lines] > 847-685-9073 > www.vadimrapp.com BF> I use BF> currentproject.connection.execute BF> "MySToredProceedure" or BF> set rs =currentproject.connection.execute( BF> "MySToredProceedure" ) BF> and the profiler shows all the BF> EXEC sp_MShelpcolumns N'ExternalOrderNumbers', BF> NULL, N'id', 1 for each table of BF> MySToredProceedure. I opened the adp; opened a module; opened immediate window; executed currentproject.connection.execute "mystoredprocedure" - and profiler showed nothing but RPC: completed exec mystoredprocedure. Vadim --------------------------------------- Vadim Rapp Consulting SQL, Access, VB Solutions 847-685-9073 www.vadimrapp.com Ok.. now I need to know what you have they don't this happens with all my XP OS XP office clients. I am running SQL 7.0 SP6a, if that makes a difference. > BF> I use > BF> currentproject.connection.execute [quoted text clipped - 17 lines] > 847-685-9073 > www.vadimrapp.com BF> Ok.. now I need to know what you have they don't BF> this happens with all my XP OS XP office clients. BF> I am running SQL 7.0 SP6a, if that makes a BF> difference. access.exe 10.4302.4219 Microsoft SQL Server 2000 - 8.00.760 (Build 2195: Service Pack 4) windows xp sp1 Did you try it exactly the way I wrote? Vadim I don't have the 2002, which is why I am asking here. I have clients that have 2002 and they all do the same thing. I don't have SQL 2000 but SQL 7. they access when I run the same ADE on 2000 I do not get all this extra communication. so I figure it has something to-do with 2002. I am trying to figure out what if anything, I need to tell my clients to-do, to their 2002 to turn off the communications. here is the code that is called. CurrentProject.Connection.Execute "dbo.ADP_LkUpOrderswithNotracking" This calls Procedure dbo.ADP_LkUpOrderswithNotracking As set nocount on execute dbwithactualSP..ADP_LkUpOrderswithNotracking return > BF> Ok.. now I need to know what you have they don't > BF> this happens with all my XP OS XP office clients. [quoted text clipped - 8 lines] > > Vadim BF> I don't have the 2002, which is why I am asking BF> here. I have clients that have 2002 and they all BF> do the same thing. I don't have SQL 2000 but SQL BF> 7. they access BF> when I run the same ADE on 2000 I do not get all BF> this extra communication. so I figure it has BF> something to-do with 2002. I am trying to figure BF> out what if anything, I need to tell my clients BF> to-do, to their 2002 to turn off the BF> communications. After all, you can open support incident with microsoft and ask them. Vadim LOL. thanks Vadim. I was hoping I would get lucky and have a MSFT person see it here and respond. I really hate going thru the hoops with the Script readers as MSFT support then have to wait for the escalation to happen, so I can talk to someone knowledgeable. Almost enough to spring for Acc2002 and a new computer to run it on, so I can trouble shoot it. > BF> I don't have the 2002, which is why I am asking > BF> here. I have clients that have 2002 and they all [quoted text clipped - 11 lines] > > Vadim |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.