Hi,
I'm currently running Zeos 6.6.5 stable under Delphi 7.
I'm connecting to MySQL 5.1. When setting the connection property on the TZStoredProc component to link to my TZConnection, and after setting my TZConnection's Active property to true, I don't see any Stored Procedures as its defined under MySQL.
The StoredProcName property under my TZStoredProc component does not display anything to select, which can be assumed it does not see anything. (?)
Can the reason be because I'm running on MySQL 5.1? I noticed that the latest protocol that is supported in the protocol property of the TZConnection component is MySQL 5.0.
Should I downgrade my MySQL to version 5.0 in order for this to work? And if so, is there a release in the pipeline that will be working with MySQL 5.1?
Thanks.
Regards,
Chris
TZStoredProc Not Working
Moderators: gto, EgonHugeist
-
mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
Chris,
For the moment there's no storedproc support for mysql. So even if the procs where there it wouldn't help.
Also, nobody implemented the UncachedGetProcedures function in the ZDbcMetadata.pas unit. Which is the reason why the functions are not in the list. I'm sure it would be easy to implement this function if you're a mysql user, however. So if you could do that, I would be very happy to include it in the official zeoslib sources. (Don't forget to add a version check to avoid trouble in older mysql versions)
Mark
For the moment there's no storedproc support for mysql. So even if the procs where there it wouldn't help.
Also, nobody implemented the UncachedGetProcedures function in the ZDbcMetadata.pas unit. Which is the reason why the functions are not in the list. I'm sure it would be easy to implement this function if you're a mysql user, however. So if you could do that, I would be very happy to include it in the official zeoslib sources. (Don't forget to add a version check to avoid trouble in older mysql versions)
Mark
