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

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

Hi

I had been struggling earlier to get the Firebird data into SQL 2005 =
Reporting Services. I was using the Firebird .Net provider for that.

I changed the source code to replace the "[]" brackets by blanks.=20
So the Data View was created by Studio.

Now when I try to design a report in Studio with this data view, I am =
getting the following error:

invalid transaction handle (expecting explicit transaction start)

The following statement is sent to the Firebird .Net provider for =
execution:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

Any idea as to what I am doing wrong or any changes I need to make to =
Enlist Transaction or other settings in the provider configuration?


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


-----Original Message-----
From: fir...@li... =
[mailto:fir...@li...] On Behalf =
Of Shreekar Joshi
Sent: Friday, October 05, 2007 11:39 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Firebird.Net and SQL Reporting =
Services

Sorry to pester you....but do you have any further information?

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

-----Original Message-----
From: fir...@li... =
[mailto:fir...@li...] On Behalf =
Of Carlos
Sent: Monday, September 17, 2007 1:11 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Firebird.Net and SQL Reporting =
Services

Hola:

> Any further ideas?

I will see if i can test it but i think the SQL Reporting services are
using hardcoded quotes.


--=20
Carlos Guzm=E1n =C1lvarez
Vigo-Spain

Blog		: http://carlosga.wordpress.com/
FirebirdClient	: http://www.firebirdsql.org/
XMPP Client	: http://code.google.com/p/xmppclient/
-------------------------------------------------------------------------=

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

-------------------------------------------------------------------------=

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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider