Access 2000 ADP SQL Server 7 STored proceedure

B

BJ Freeman

I have a db that redirects stored procedures to other DB on the server
example:
Procedure ADP_CompleteXMLOrderImport
As
set nocount on
EXECUTE db0102070001..ADP_CompleteXMLOrderImport
EXECUTE db0102070002..ADP_CompleteXMLOrderImport
EXECUTE db0102070003..ADP_CompleteXMLOrderImport
EXECUTE db0102070004..ADP_CompleteXMLOrderImport
return


ADP_CompleteXMLOrderImport is called from an ADP.
up till a while ago this worked with no problems.
Now EXECUTE db0102070003..ADP_CompleteXMLOrderImport
redirect to some other db.
all the other exec work fine.

If I run this from the query analyzer it work fine.
the Profiler shows: EXECUTE ADP_CompleteXMLOrderImport

So I am convince it has something to-do with the ADP
Any thoughts where I should look, or further troubles shooting steps I might
try.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't create persistent ## tables with ADP call to a stored procedure(!?) 2
Access 2000 ADP and SQL Server 2005 2
ADP Update Query does NOT update ! 3
Access can't find stored procedure after scripting on sql server 2
The stored procedure executed successfully but did not return any records 4
Adodb connection to different SQL SERVER DB 3
The stored procedure executed successfully but did not return anyrecords 1
Stored procedure as row source for a combo box 4

Top