[Firebird-net-provider] Firebird.Net and SQL Reporting Services

[Shreekar J. <Shr...@kp...>]

Hi

=20

First of all, thanks a lot for the efforts on the Firebird.Net provider.

=20

Sorry for appearing out of the blue. I am stuck on one error which I
need some help with.

=20

I am using the following:

=20

VS 2005

SQL 2005 Reporting Services

Firebird.Net Data Provider 2.0

Firebird Database 1.5

=20

This is what I am trying to do:

=20

In SQL Server 2005 Analysis project,

=20

Create a Data Source

Create a Data Source View

And

Create a Report Model

=20

I have successfully created the data source.=20

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:

=20

<Error start>

=20

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

=20

Dynamic SQL Error

SQL error code =3D -104

Token unknown - line 3, char 8

[ (Microsoft Visual Studio)

=20

------------------------------

Program Location:

=20

   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()

=20

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

=20

Exception of type 'FirebirdSql.Data.Common.IscException' was thrown.
(FirebirdSql.Data.FirebirdClient)

=20

------------------------------

Program Location:

=20

   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)

=20

<Error end>

=20

Few notes:

=20

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.

=20

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?

=20

Thanks in advance.

Shreekar Joshi=20
KPIT Cummins Infosystems Ltd.| Ph: +91 020 6652 5000 extn. 2001=20
http://www.kpitcummins.com <http://www.kpitcummins.com>=20
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.

=20