Dears all,
My Dude!!!
Does MyODBC 5 support Stored Procedures. How cant I retrieve Stored
Procedures arguments in Visual basic?
--
Conrado Peraza
Developer IT
E-mail: conrado.peraza@brascuba.cu
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
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: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org