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
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
"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
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 connecti
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. Also, anyone know of a f
