MySQL Forums
Forum List  »  Newbie

Re: Having trouble filling a DataGrid (VB 6) using a stored procedure
Posted by: Javier Rodriguez Paiva
Date: June 30, 2005 08:26AM

Hi James, it seems myODBC 3.51 doesn't fully support the use of stored procedures. You can't use stored procedures to fetch data yet, however, procedures for inserting, updating and deleting work fine (when being called from Visual Basic using ADO/myODBC)
I was told that myODBC 3.53 should fix that, that new release should be coming out.... well.... someday.
For the time being, I read all tables with a direct SELECT from the component (all other transactions are done with stored procedures), which requires you to grant select privilege to almost all of your accounts.

Options: ReplyQuote


Subject
Written By
Posted
Re: Having trouble filling a DataGrid (VB 6) using a stored procedure
June 30, 2005 08:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.