＆QUOT;命令执行＆QUOT过程中遇到的致命错误;试图从MySQL数据库添加视图时， [英] "fatal error encountered during command execution" when trying to add a view from MySQL DB

问题描述

我想从MySQL数据库中添加一些表和视图在VS2005的项目。很多环视我最终使用ADO.NET连接器，其工作方式pretty的罚款，尝试添加与数据源配置向导，在这里我得到的错误中命令执行时遇到致命错误视图时，除非后消息，当我尝试添加一个与查询生成器，它并没有在关系图窗格中显示我列的名称。 如果我用手工添加所有的SELECT命令，它的工作原理就像一个魅力。在什么可能导致这个问题以及如何解决它？任何想法

I'm trying to add some tables and views from a MySQL database to a project in VS2005. After a lot of looking around I ended using the ADO.NET connector, which works pretty fine, except when trying to add a View with the Data source configuration wizard, where I get the "fatal error encountered during command execution" error message, and when I try adding one with the query builder, where it doesn't show me the name of the columns at the diagram pane. If I add all the SELECT commands by hand, it works like a charm. Any ideas on what might be causing this and how to fix it?

推荐答案

看起来像View使用变量

Looks like View uses variables

要解决此附加'允许用户   变量=真正的'到您的连接   串。在此模式下它不会   当它看到@data但抱怨   没有找到该名称的参数。

To fix this add 'allow user variables=true' to your connection string. In this mode it will not complain when it sees @data but doesn't find a parameter of that name.

http://bugs.mysql.com/bug.php?id=40765

这篇关于＆QUOT;命令执行＆QUOT过程中遇到的致命错误;试图从MySQL数据库添加视图时，的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！