------_=_NextPart_001_01C6AA72.6E24E6AE
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
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?
------_=_NextPart_001_01C6AA72.6E24E6AE--
On 7/18/06, Barty, Joe (GE Infra, Non-GE, US)
> 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?
I take it you want to access an SP that returns row values (more than
one result). Support for this in the latest version of 3.51.x is
broken and I cannot see it fixed as all effort is now put in the new
5.0.x client for MyODBC. Mileage with the current alpha version
varies, I for one cannot use it to connect to a database. SP support
should be in it though.
Regards,
Frank
--
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
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?
>
I don't know if this is relevent, but on the version of Crystal Reports
that I use (8.5), when you select your database using Data Explorer,
there is an "Options" button where you must explicitly tell it to show
you tables or stored procedures. The default, if I remember correctly,
is NOT to show either stored procedures or tables without changing that
preference.
HTH
Kenn
--
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
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@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