• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 993
  • Last Modified:

Crystal Report Cannot Bind MySQL Data Set

am trying to create a Crystal Report connected to a MySQL database using an ODBC (RDO) connection.  I created a DSN using the MySQL Connector/ODBC 3.51.  When creating a new report I can add the ODBC (RDO) connection without a problem in Crystal Reports XI "Standard Report Creation Wizard".  All the table names,SP are displayed in the "Available Data Sources" pane.  However when I try to move some of the tables or (SP) to the "Selected Tables" pane, I get the following error:  

  Database Connector Error: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt] does not support this yet  , Then If I move it will not explore the attributes (fields) tree of the Table or Sp , On The server machine MYSQL version is (5.0.45) , I have also (.NET Framework Data Provider for MySQL) on my (.NET 2005) soSo any one can help us how to solve this problem?

0
mubama0n
Asked:
mubama0n
  • 3
  • 2
  • 2
  • +1
1 Solution
 
frodomanCommented:
Are you moving one table or several?  There are some specific types of joins that MySql doesn't support.

Are you using the version of Crystal that's embedded with VS2005 or a standalone version?  If standalone please identify the version & edition.

frodoman
0
 
mubama0nAuthor Commented:
I'm Using Crystal that's embedded with VS2005 , I'm Moving Only One Table Or One (SP).
0
 
mlmccCommented:
I assume you have permissions to the table or SP?

mlmcc
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
mubama0nAuthor Commented:
No There Is No any type of security issues , write on google this word :
ERROR [HY000] [MySQL][ODBC 3.51 Driver][

And try to search you will find many type of errors like this , I'm afraid that (MySQl) is not working with (.NET) but I dont have evidence about this fact, I want to know weather any body did application on (.NET) either (Windows or web) application and MySQL with the same version at the back end without any problem.
0
 
frodomanCommented:
I don't user MySql personally but I've heard of plenty of .Net apps that have used it.  If the problem is with Crystal making the connection to MySql, you may have to use .Net to create a dataset and then build your report based on the dataset instead of a direct connection.

If you take that approach, this document has a walkthrough for basing reports on datasets: http://www.businessobjects.com/global/pdf/dev_zone/VS2005_Walkthroughs.pdf


frodoman
0
 
mlmccCommented:
0
 
mubama0nAuthor Commented:
Sorry Your solutions is not working here is the Needed solution that let any one connecting (MYSQL) through .NET without any problem:
http://www.crlab.com/mysqlnet/

I'll keep the question to be Judged by the administrator of this website.
0
 
Computer101Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now