By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,553 Members | 946 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,553 IT Pros & Developers. It's quick & easy.

How to Return output parameter from Stored Procedure in MySql From Access 2003

P: 2
I call SP from Access 2003 using qrydef (I am using DAO and my Access Tables link to MySQL DB with ODBC connection.
I create SP in MySQL with Transaction and Error Handler.
It is working find with out return any parameters(Error Msg)
But I need to know is transaction commit or rollback(if we have any error)
I can read this output parameter in Mysql with Query Editor.
How I can pass this parameter or any string back to VBA Access 2003
Thank you!!!
Mar 22 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.