Crystal Report Cannot Bind MySQL Data Set
Posted on 2007-10-17
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?