Barty, Joe (GE Infra, Non-GE, US) wrote:
> We are trying to access a stored procedure from Crystal Reports via the
> MySQL ODBC driver. We can see the tables as objects but not the Stored
> Procedures. Doe anyone know how to fix this issue?
>
Not being able to 'see' the stored procedure in Crystal Reports doesn't
necessarily mean that you can't access it. Crystal Reports probably
needs to be updated to support MySQL stored procedures. In the meantime,
you *may* be able to get things working, if you can manually send an SQL
command, instead of relying on Crystal Reports to know what you're
trying to do. Simply send a:
call PROCEDURE_NAME()
command at MySQL to trigger the procedure. As others have noted, though,
using MyODBC-3.51.x to retrieve results from stored procedures doesn't
quite work in some situations. I *have* been able to make it work with
MyODBC-3.51.13, however using this driver caused MS Access ( 2002 ) to
crash on me every 90 seconds or so. Perhaps you will have more luck with
Crystal Reports. Otherwise keep an eye on the new 5.x series.
--
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@stripped
website: http://www.nusconsulting.com.au
