Re: MySQL Stored procedures Supprot
Daniel Kasak <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
Conrado Peraza wrote: > Dears all, > My Dude!!! My Man!!! :) > Does MyODBC 5 support Stored Procedures. In theory. You can use the command-line 'mysql' client to execute stored procedures. > How cant I retrieve Stored Procedures arguments in Visual basic? In practice things are a little different. Stored procedures are still highly experimental and not yet supported by the client libraries. You can try out the experimental MyODBC-5 driver and see how you go. From pure VB you might have some luck, though this driver doesn't yet work with MS Office applications. There are many sites ( including Microsoft's knowledge base ) that give details on how to execute stored procedures from VB & ADO, and retrieve recordsets and parameters. Here's an IBM page on the topic: http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.sample.doc/doc/vb/s-spCall-bas.htm -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [email protected] website: http://www.nusconsulting.com.au -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]