[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Crystal Report Cannot Bind MySQL Data Set

Posted on 2007-10-17
9
Medium Priority
?
989 Views
Last Modified: 2013-11-26
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
Comment
Question by:mubama0n
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 42

Expert Comment

by:frodoman
ID: 20092255
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
 

Author Comment

by:mubama0n
ID: 20092398
I'm Using Crystal that's embedded with VS2005 , I'm Moving Only One Table Or One (SP).
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 20094419
I assume you have permissions to the table or SP?

mlmcc
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

Author Comment

by:mubama0n
ID: 20095036
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
 
LVL 42

Expert Comment

by:frodoman
ID: 20095329
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 20096083
0
 

Author Comment

by:mubama0n
ID: 20107006
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
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22434196
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month20 days, 8 hours left to enroll

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question