 |
MySQLTalk.org
MYSQL discussions groups
|
| View previous topic :: View next topic |
| Author |
Message |
Barty, Joe (GE Infra, Non
Guest
|
 Posted: Tue Jul 18, 2006 6:59 pm Post subject: Accessing Stored Procedures via ODBC |
 |
|
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? |
|
| Back to top |
|
 |
Frank Maas
Guest
|
| Posted: Tue Jul 18, 2006 8:46 pm Post subject: Fwd: Accessing Stored Procedures via ODBC |
|
|
On 7/18/06, Barty, Joe (GE Infra, Non-GE, US) <joe.barty (AT) ae (DOT) ge.com> wrote:
| Quote: | 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 |
|
| Back to top |
|
|
kenn
Guest
|
| Posted: Tue Jul 18, 2006 8:52 pm Post subject: Re: Accessing Stored Procedures via ODBC |
|
|
Barty, Joe (GE Infra, Non-GE, US) wrote:
| Quote: | 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 |
|
| Back to top |
|
|
Daniel Kasak
Guest
|
| Posted: Wed Jul 19, 2006 3:14 am Post subject: Re: Accessing Stored Procedures via ODBC |
|
|
Barty, Joe (GE Infra, Non-GE, US) wrote:
| Quote: | 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 (AT) nusconsulting (DOT) com.au
website: http://www.nusconsulting.com.au |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
