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