Calling SQL Server Stored Procedures using DAO
Posted on 1998-08-06
I'm trying to call a stored procedure using DAO on a SQL server. I've seen and tried examples for RDO but i don't know what that is and i can't get it to work either.
I have no problems sending queries using OpenRecordset and getting the results that way, so i know i'm connecting properly.
I need a detailed description of how to connect to a SQL server database, call a stored procedure and have it return results to me. i also need to be able to send data to the stored procedure that updates records and doesnt return results. and even more if the stored procedure is made to send an error message if something happens i need it to be able to send that back to me rather then the 'ODBC -- connection failed' error.