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(Erro r 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!!!
Mike
I create SP in MySQL with Transaction and Error Handler.
It is working find with out return any parameters(Erro r 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!!!
Mike