Re: Calling Stored Procedures with MS Access Pass-Through Queries

2005-08-09 Thread Daniel Kasak
Kent Roberts wrote: Has anyone had experience with this yet? My attempts so far render "ODBC--call failed". My connection is good and I can use select statements successfully, but no luck with calling an SP yet. I really want to call an SP with parameters, but I'm trying a simple one first. A

Re: Calling Stored Procedures with MS Access Pass-Through Queries

2005-08-09 Thread Kent Roberts
Thanks Shawn. I'm actually trying using Access's Pass-Through Query technology which utilizes ODBC. I'm not sure if it's ADO or DAO. I'll guess ADO since that's the default for this version of Access (2002). I haven't tried connecting in code yet, but that's coming soon. I've had a lot of experienc

Re: Calling Stored Procedures with MS Access Pass-Through Queries

2005-08-09 Thread SGreen
"Kent Roberts" <[EMAIL PROTECTED]> wrote on 08/09/2005 12:24:11 PM: > Has anyone had experience with this yet? My attempts so far render > "ODBC--call failed". My connection is good and I can use select > statements successfully, but no luck with calling an SP yet. I > really want to call an SP

RE: Calling Stored Procedures with MS Access Pass-Through Queries

2005-08-09 Thread Kent Roberts
It might help if I mention my syntax is: call spTestingStuff(); From: KentĀ RobertsDate: August 9 2005 6:24pm Subject: Calling Stored Procedures with MS Access Pass-Through Queries Has anyone had experience with this yet? My attempts so far render = "ODBC--call failed". My connection is good an