I have the following stored procedure
CREATE PROCEDURE [MONA].[spCarrierInfo]
AS Select *
where CC = @Carriercode
Then I call it from within MS Access with a Pass Through query with the DSN, which does work because I can do regular queries and get the results.
well I call the SP like this:
exec [MONA].[spCarrierInfo] @CarrierCode= 'OTITEN'
I get no errors but neither do I get any result sets. Any ideas?