将Progress DB连接到SQL报表模型 [英] Connecting Progress DB to SQL Report Model
问题描述
好的，这个问题很重要：
我想在MS Visual Studio 2005中创建一个报表模型项目，连接到Progress Openedge数据库。
我可以成功连接到进度数据库，并从SQL Reporting Services中提取一些数据。但是，当我尝试创建一个报表模型项目时，我会收到错误。
首先，我创建一个新的数据源，并测试连接，它工作正常。 Connection方法是ODBC，使用"Progress Openedge 10.2A Driver"。
然后我尝试创建数据源视图。我可以看到表格，并选择我想要包含的表格，但是，当我点击完成后，我收到以下错误：
= ========== =========================
有错误[HY000] [DataDirect] [ODBC进度OpenEdge线程协议驱动程序] [OPENEDGE ] SQL语句中的语法错误在"[PUB]。[AHFaultAction]"处或附近。 （10713）（pgoe1023.dll）
------------------------------
程序位置：
在System.Data.Odbc.OdbcConnection.HandleError（OdbcHandle hrHandle，RetCode retcode）
在System.Data.Odbc.OdbcCommand.ExecuteReaderObject（CommandBehavior behavior，String method，Boolean needReader，Object [] methodArguments，SQL_API odbcApiMethod）
在System.Data.Odbc.OdbcCommand.ExecuteReaderObject（CommandBehavior behavior，String method，Boolean needReader）
在System.Data.Odbc.OdbcCommand.ExecuteReader（CommandBehavior）行为）
在System.Data.Odbc.OdbcCommand.ExecuteDbDataReader（CommandBehavior行为）
在System.Data.Common.DbCommand.ExecuteReader（CommandBehavior行为）
在Microsoft.DataWarehouse.Design.DataSourceConnection .FillDataSet（DataSet dataSet，String schemaName，String tableName，String tableType）
在Microsoft.AnalysisServices.Design.DSVUtilities.ExportDataSet（DataSourceView& dsv，DataSourceConnec） concon，ArrayList tableList，ArrayList viewList，ArrayList sysTableList，ArrayList sysViewList，IServiceProvider serviceProvider，ProgressBar progressBar）
在Microsoft.AnalysisServices.Wizards.DSVWizardForm.OnFinish（CancelEventArgs e）
=== =====================
做了一些搜索，我发现这很可能是SQL put square的一个问题声明周围的括号，Progress不承认。
相关主题：http：//www.progresstalk.com/showthread.php？p = 351153
有没有办法解决这个问题？
我是我真的很想知道这个问题。它阻碍了一些重大进步......
Ok, big question this one:
I want to create a report model project in MS Visual Studio 2005, connecting to a Progress Openedge Database.
I can successfully connect to the progress database, and pull some data from SQL Reporting Services. However, when I try to create a report model project, I get errors.
Firstly, I create a new data source, and test the connection, and it works fine. The Connection method is ODBC, using "Progress Openedge 10.2A Driver".
I then attempt to create a Data Source View. I can see the tables, and choose which ones I want to include, however, when I click finish, I get the following error:
===================================
ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about "[PUB].[AHFaultAction]" (10713) (pgoe1023.dll)
------------------------------
Program Location:
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.DataWarehouse.Design.DataSourceConnection.FillDataSet(DataSet dataSet, String schemaName, String tableName, String tableType)
at Microsoft.AnalysisServices.Design.DSVUtilities.ExportDataSet(DataSourceView& dsv, DataSourceConnection conn, ArrayList tableList, ArrayList viewList, ArrayList sysTableList, ArrayList sysViewList, IServiceProvider serviceProvider, ProgressBar progressBar)
at Microsoft.AnalysisServices.Wizards.DSVWizardForm.OnFinish(CancelEventArgs e)
========================
Doing a bit of searching around, and I have found this is most likely an issue with SQL putting square brackets around the statement, which Progress doesnt recognise.
Relevant topic: http://www.progresstalk.com/showthread.php?p=351153
Is there any way to fix this?
I am really doing my head in with this problem. It is holding back some major advances...
推荐答案
我也遇到了同样的问题。
错误如下：错误[HY000] [DataDirect] [ODBC Progress OpenEdge线路协议驱动程序]连接到数据源的信息不足。
但是ODBC连接正确创建并且成功连接？!!？
你看起来比我做得更远。至少你可以创建数据源。你是怎么做到的？
我已经查看了Progress，DataDirect和OpenLink论坛，但一无所获！我将检查stackoverflow.com
I am also having the same problem.
The error is the following: Error [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver] Insufficient information to connect to the data source.
Yet the ODBC connection is created correctly and connects succesfully?!!?
It looks like you got further than I did. At least you are able to create the data source. How did you do that?
I have checked on the Progress, DataDirect and OpenLink forums and have found nothing! I will check on stackoverflow.com
这篇关于将Progress DB连接到SQL报表模型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
