Bug #13764 Unable to See Stored Procedure and Views in Crystal Reports
Submitted: 5 Oct 2005 8:47 Modified: 8 Oct 2005 4:18
Reporter: santosh multhalli Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:5.0.alpha OS:Windows (Windows 2003)
Assigned to: MySQL Verification Team CPU Architecture:Any

[5 Oct 2005 8:47] santosh multhalli
Description:
When I add crystal report to a VB.net, and connect to mysql 5.0.13 through the dataSource created  by mysql 5.0. alpha I am unable to see the the Stored Procedures and Views that I have created in the dataBase

How to repeat:
follow the below steps to recreate the bug

1)Create new datbase in mysql 5.0.13 server 
2)Create a table test with fields (id varchar(50),Name varchar(50)) in database
3)create a simple view that includes table test
4)create a Stored procedure testSP that retrives records from test

5)create a datasource to the above mentioned database using myodbc 5.0 

6)Open new project in VisualStudio in VB.net add a crystal report file to it
7)in standard report expert panel select the ODBC folder it will list a set of ODBC datsources Select datasource related to mysql odbc 5.0 and u will not find any Stored Procedure and Views that u have earlier created in database . 

Suggested fix:
not known
[5 Oct 2005 11:19] Vasily Kishkin
Could you please create and attach project in VisualStudio in VB.net ?
[6 Oct 2005 7:53] santosh multhalli
projectthat creates bugs

Attachment: WindowsApplication1.zip (application/x-zip-compressed, text), 38.03 KiB.

[6 Oct 2005 7:57] santosh multhalli
the script that creates required database

Attachment: newdatbase.sql (text/plain), 1.20 KiB.

[6 Oct 2005 7:58] santosh multhalli
after running the script named newdatbase.sql create a datasource named 
mysqltest using mysqldriver 5.0. alpha
[8 Oct 2005 4:14] MySQL Verification Team
Showing the view

Attachment: buh13764.PNG (image/x-png, text), 27.25 KiB.

[8 Oct 2005 4:18] MySQL Verification Team
I opened your own project file, created the database with your script
and you can see the view in the picture I attached while in design view.
Stored Procedures are not showed for this purpose, use the command
show create procedure for.

Thank you for the bug report.