Hi
First of all, thanks a lot for the efforts on the Firebird.Net provider.
Sorry for appearing out of the blue. I am stuck on one error which I
need some help with.
I am using the following:
VS 2005
SQL 2005 Reporting Services
Firebird.Net Data Provider 2.0
Firebird Database 1.5
This is what I am trying to do:
In SQL Server 2005 Analysis project,
Create a Data Source
Create a Data Source View
And
Create a Report Model
I have successfully created the data source.
When I try to create a Data Source View, it lists all the tables in the
Firebird database.
In the last step, when VS tries to import the metadata to its storage (I
think), the Firebird Client throws the following exception:
<Error start>
===================================
Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, char 8
[ (Microsoft Visual Studio)
------------------------------
Program Location:
at
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior
behavior)
at
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBeh
avior 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.DataSourceDesigner.AddRemoveObjectsFro
mDSV()
===================================
Exception of type 'FirebirdSql.Data.Common.IscException' was thrown.
(FirebirdSql.Data.FirebirdClient)
------------------------------
Program Location:
at FirebirdSql.Data.Client.Gds.GdsConnection.ReadStatusVector()
at FirebirdSql.Data.Client.Gds.GdsConnection.ReadResponse()
at FirebirdSql.Data.Client.Gds.GdsDatabase.ReadResponse()
at FirebirdSql.Data.Client.Gds.GdsStatement.Prepare(String
commandText)
at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean
returnsSet)
at
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior
behavior, Boolean returnsSet)
at
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior
behavior)
<Error end>
Few notes:
If I remove the checkbox of "Create logical relationships by matching
columns", the wizard proceeds smoothly. But when I open the data source
view, there are no tables there and if I try to add more tables, I
receive the same above error.
I am also trying to follow this up with MS, since the error was thrown
by Firebird DLL, I thought of asking you first. Can you provide me some
direction/information as to what I might be doing wrong?
Thanks in advance.
Shreekar Joshi
KPIT Cummins Infosystems Ltd.| Ph: +91 020 6652 5000 extn. 2001
http://www.kpitcummins.com <http://www.kpitcummins.com>
Disclaimer: This message contains information that may be privileged or
confidential and is the property of KPIT Cummins. It is intended only
for the person to whom it is addressed. If you are not the intended
recipient, you are not authorized to read, print, retain copy,
disseminate, distribute, or use this message or any part thereof. If you
receive this message in error, please notify the sender immediately and
delete all copies of this message. KPIT Cummins does not accept any
liability for virus infected mails.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
