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. 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 KPIT Cummins Infosystems Ltd.| Ph: +91 020 6652 5000 extn. 2001 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 KPIT Cummins Infosystems Ltd.| Ph: +91 020 6652 5000 extn. 2001 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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. -- Carlos Guzmán Álvarez 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 Firebird-net-provider@lists.sourceforge.net 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 Firebird-net-provider@lists.sourceforge.net 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
