无法将Crystal Reports的存储过程从SQL Server迁移到MySQL

I have been trying to migrate a SQL Server 2005 database to MySQL 5.5.29 and having trouble with the reports done with Crystal Reports 2010. I can use the set datasource location to migrate the tables (I do have to do each one individually and rename it before it will migrate) but I got it done.

我一直在尝试将SQL Server 2005数据库迁移到MySQL 5.5.29并且无法使用Crystal Reports 2010完成报告。我可以使用set datasource位置来迁移表(我必须单独执行每个表并重命名它会迁移之前)但我完成了它。

However, I'm not able to update the stored procedure as I get the message:

但是,当我收到消息时,我无法更新存储过程:

Database Connector Error: 'HY00:[MySQL][ODBC 5.1 Driver][mysqld-5.5.28-lof]SELECT command denied to user ... [Database Vendor Code: 1142]

数据库连接器错误:'HY00:[MySQL] [ODBC 5.1驱动程序] [mysqld-5.5.28-lof] SELECT命令被拒绝给用户... [数据库供应商代码:1142]

I'm using the same ODBC Source as used for the tables so I don't know what I have to do to update/migrate the stored procedure. I tried to create a new report and add a stored procedure but get the same message.

我正在使用与表中使用的相同的ODBC源,所以我不知道我需要做什么来更新/迁移存储过程。我尝试创建一个新报告并添加一个存储过程,但获得相同的消息。

Any ideas?

Thanks,

Vic

2 个解决方案

#1

Based on the error message, the user the report is being executed as genuinely does not have access to the specified table.

根据错误消息,正在执行报表的用户无法访问指定的表。

The MySQL bug report Escaped wildcard in DB name prevents user from granting database permissions may shed some light on why permissions may not be applied as you think they are when the db name contains an underscore.

MySQL错误报告数据库名称中的转义通配符会阻止用户授予数据库权限,这可能会解释为什么在数据库名称包含下划线时可能无法应用权限的原因。

#2

This is a restriction by the provider and they refuse to change it. Because of this I am not able to include stored procedures in a Crystal Report.

这是提供商的限制,他们拒绝改变它。因此,我无法在Crystal Report中包含存储过程。

#1