Re: calling stored procedure trough ODBC
"sonotronic sonotronic" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc,gmane.comp.db.mysql.general |
|---|---|
| Message-ID | <[email protected]> |
CPK, you may call stored procedures from Access executing a pass through query with the SQL in the form: SPname, param1, param2 . This is the only way I know to execute SP from Access. I have a passthrogh query in Access with Returning Rows property True and another False and I modify the SQL property of the query in the code before executing. Regards, Valentin Playa Madrid, Spain ******************************************************************************************* On 8/4/07, C K <[email protected]> wrote: > > Hello, > I am using MySQL 5.0.17 and MyODBC 3.51.14. > I ma using MS Access 2003 as front-end > Can I call stored procedures from Access ? how ? > Also can we use ODBC driver for calling stored procedures or linking SP to > Access? > > Please help > Thanks > CPK > > -- > Keep your Environment clean and green. >