Re: [Firebird-net-provider] COALESCE in select
On 8/4/07, Jiøí Neu¾il [EMAIL PROTECTED] wrote: Hi, I'm using Firebird .NET DataProvider 2.1 RC1 and when I use coalesce(decimal_column, 0) in my select command I get: SQL Execution Error. Executed SQL Statement: SELECT.. Error Source: Firebird.Data.FirebirdClient Error Message: Dynamic SQL Error SQL error code = -804 Function unknown coalesce If I execute same SQL command in IBExpert everything is OK. This is error from FB server. Are you using same server as connecting from IBE? What's the version? How looks the command in code? -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - 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
[Firebird-net-provider] Update of Visual Studio solition/project files on svn trunk
Hello: I'm going to convert the solution/project files to Visual Studio 2008 Beta 2( with compilation against the .NET Framework 3.5 ), does somebody have any problem with that change ?? ( the sources should be buildable with .net 2.0 using the nant scripts or changing the build options of the new solution files ) -- Best regards Carlos Guzmán Álvarez Vigo-Spain - 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
Re: [Firebird-net-provider] COALESCE in select
Hi, thanks for reply, yes, same server (FB 2.0.1), same DB. This is the command: select sum(o_osev.plocha) as plocha,sum(s_sumsklizen.suma) as vynos,z_hon.nazevhon, o_plodina.plodnazev, coalesce(s_prumcena.prumcena,0) from o_osev left join o_odruda on o_osev.idodruda = o_odruda.odrkod left join o_plodina on o_odruda.plodid = o_plodina.plodkod left join s_prumcena on o_plodina.plodkod = s_prumcena.plodkod left join z_hon on o_osev.idhon = z_hon.idhon left join s_sumsklizen on s_sumsklizen.idosev = o_osev.id group by z_hon.nazevhon, o_plodina.plodnazev, s_prumcena.prumcena. I have copied it to VS 2005 TableAdapter designer, to TableAdapter.SelectCommand (many others select commands works fine). Thanks. Původní zpráva Od: Jiri Cincura [EMAIL PROTECTED] Předmět: Re: [Firebird-net-provider] COALESCE in select Datum: 04.8.2007 09:59:38 On 8/4/07, Jiøí Neu¾il [EMAIL PROTECTED] wrote: Hi, I'm using Firebird .NET DataProvider 2.1 RC1 and when I use coalesce(decimal_column, 0) in my select command I get: SQL Execution Error. Executed SQL Statement: SELECT.. Error Source: Firebird.Data.FirebirdClient Error Message: Dynamic SQL Error SQL error code = -804 Function unknown coalesce If I execute same SQL command in IBExpert everything is OK. This is error from FB server. Are you using same server as connecting from IBE? What's the version? How looks the command in code? -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - 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
Re: [Firebird-net-provider] Update of Visual Studio solition/project files on svn trunk
Hi, only for info, .NET 3.5 Beta 2 change your installation of .NET 2.0: http://community.devexpress.com/blogs/ctodx/archive/2007/07/31/system-data-breaking-changes-in-latest-net-framework-update.aspx Původní zpráva Od: Carlos Guzmán Álvarez [EMAIL PROTECTED] Předmět: [Firebird-net-provider] Update of Visual Studio solition/project files on svn trunk Datum: 04.8.2007 11:19:42 Hello: I'm going to convert the solution/project files to Visual Studio 2008 Beta 2( with compilation against the .NET Framework 3.5 ), does somebody have any problem with that change ?? ( the sources should be buildable with .net 2.0 using the nant scripts or changing the build options of the new solution files ) -- Best regards Carlos Guzmán Álvarez Vigo-Spain - 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
Re: [Firebird-net-provider] Update of Visual Studio solition/project files on svn trunk
On 8/4/07, Carlos Guzmán Álvarez [EMAIL PROTECTED] wrote: Hello: I'm going to convert the solution/project files to Visual Studio 2008 Beta 2( with compilation against the .NET Framework 3.5 ), does somebody have any problem with that change ?? ( the sources should be buildable with .net 2.0 using the nant scripts or changing the build options of the new solution files ) No problem for me. I have VS 2008 in VPC so I'm able to open sources. -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - 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
Re: [Firebird-net-provider] Update of Visual Studio solition/project files on svn trunk
Can't be made a 'copy' of sln file? Like FirebirdSql.Data.FirebirdClient2008.sln! Like that it can be open with both VS !!! Best Regards, Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carlos Guzmán Álvarez Sent: Saturday, August 04, 2007 12:16 PM To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Update of Visual Studio solition/project files on svn trunk Hello: I'm going to convert the solution/project files to Visual Studio 2008 Beta 2( with compilation against the .NET Framework 3.5 ), does somebody have any problem with that change ?? ( the sources should be buildable with .net 2.0 using the nant scripts or changing the build options of the new solution files ) -- Best regards Carlos Guzmán Álvarez Vigo-Spain --- -- 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
[Firebird-net-provider] OT: Firebird built-in function list
Hello: Is there any place where i can find a list of firebird built-in functions with the description of the input parameters and return values ?? Thanks in advance !! -- Best regards Carlos Guzmán Álvarez Vigo-Spain - 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
Re: [Firebird-net-provider] Update of Visual Studio
Hello: Can't be made a 'copy' of sln file? Like FirebirdSql.Data.FirebirdClient2008.sln! Like that it can be open with both VS !!! Web can but with that we will need to mantain two sets of solution/project files. - 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
[Firebird-net-provider] VISTA Embedded Problem
Hi all, I am developing a program using the embedded DB. When I run it on VISTA as a user who has admin rights, it runs OK. When I run it as a standard user, it fails to connect to the embedded DB. If I point it to a server which is running Firebird, it works for either user. My assumption is that the standard user is not able to load the embeddeded dll. Any thoughts on how to solve this problem? TIA Marv - 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
Re: [Firebird-net-provider] Update of Visual Studio solition/project files on svn trunk
On 8/4/07, Mercea Paul [EMAIL PROTECTED] wrote: Can't be made a 'copy' of sln file? Like FirebirdSql.Data.FirebirdClient2008.sln! Like that it can be open with both VS !!! Hoe to sync adding/removing/moving etc. files in solution? ;) -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - 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
Re: [Firebird-net-provider] OT: Firebird built-in function list
On 8/4/07, Carlos Guzmán Álvarez [EMAIL PROTECTED] wrote: Hello: Is there any place where i can find a list of firebird built-in functions with the description of the input parameters and return values ?? Thanks in advance !! What FB Server version? -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - 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
Re: [Firebird-net-provider] VISTA Embedded Problem
On 8/4/07, Marvin Cook [EMAIL PROTECTED] wrote: Hi all, I am developing a program using the embedded DB. When I run it on VISTA as a user who has admin rights, it runs OK. When I run it as a standard user, it fails to connect to the embedded DB. If I point it to a server which is running Firebird, it works for either user. My assumption is that the standard user is not able to load the embeddeded dll. Any thoughts on how to solve this problem? Any exception? Any message in event log? Where's the fbembed.dll located? -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - 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
Re: [Firebird-net-provider] OT: Firebird built-in function list
Hello: What FB Server version? For the 2.1 ^^ -- Best regards Carlos Guzmán Álvarez Vigo-Spain - 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
Re: [Firebird-net-provider] Update of Visual Studio solition/project files on svn trunk
Hi Jiri I take a look at sln file and I see reference only to project files(FirebirdSql\Data\FirebirdSql.Data.FirebirdClient.csproj) and not to all files in projects. This could be a minimal modification, if it will. It's just a thought. Regards, Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Cincura Sent: Saturday, August 04, 2007 9:13 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Update of Visual Studio solition/project files on svn trunk On 8/4/07, Mercea Paul [EMAIL PROTECTED] wrote: Can't be made a 'copy' of sln file? Like FirebirdSql.Data.FirebirdClient2008.sln! Like that it can be open with both VS !!! Hoe to sync adding/removing/moving etc. files in solution? ;) -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com --- -- 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
Re: [Firebird-net-provider] OT: Firebird built-in function list
Do you meen something like UDF\ib_udf.sql and fbudf.sql??? In FB2.1 in udf dir is ib_udf2.sql and fbudf.sql with new ones! Regards, Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carlos Guzmán Álvarez Sent: Saturday, August 04, 2007 5:00 PM To: For users and developers of the Firebird .NET providers Subject: [Firebird-net-provider] OT: Firebird built-in function list Hello: Is there any place where i can find a list of firebird built-in functions with the description of the input parameters and return values ?? Thanks in advance !! -- Best regards Carlos Guzmán Álvarez Vigo-Spain --- -- 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
Re: [Firebird-net-provider] VISTA Embedded Problem
Jiri, The fbembed.dll is in the executable folder and I am using the new ClientLibrary connection string builder data element to point to it. Works fine if my development account runs it. With a regular user, the program throws an exception. The details are: ** Exception Text ** FirebirdSql.Data.FirebirdClient.FbException: operating system directive CreateFileMapping failed --- FirebirdSql.Data.Common.IscException: Exception of type 'FirebirdSql.Data.Common.IscException' was thrown. at FirebirdSql.Data.Client.Embedded.FesDatabase.ParseStatusVector(Int32[] statusVector) at FirebirdSql.Data.Client.Embedded.FesDatabase.Attach(DatabaseParameterBuffer dpb, String dataSource, Int32 port, String database) at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() --- End of inner exception stack trace --- at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create() at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut() at FirebirdSql.Data.FirebirdClient.FbConnection.Open() at Infotech.TDBQuery.Generator(String GenName, Int32 pitch) in D:\Work\InfotechLib\InfotechFB.cs:line 154 at Infotech.TDBQuery.get_NewRid() in D:\Work\InfotechLib\InfotechFB.cs:line 181 at TimeCardNet.InfotechConnectionStringBuilder.btnTest_Click(Object sender, EventArgs e) in D:\Work\TimeCardNet\TimeCardNet\InfotechConnectionStringBuilder.cs:line 150 at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message m) at System.Windows.Forms.ButtonBase.WndProc(Message m) at System.Windows.Forms.Button.WndProc(Message m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ** Loaded Assemblies ** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100) CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll TimeCardNet Assembly Version: 1.0.0.0 Win32 Version: 1.0.0.0 CodeBase: file:///D:/Work/TimeCardNet/TimeCardNet/bin/Debug/TimeCardNet.exe System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll System Assembly Version: 2.0.0.0 - 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
Re: [Firebird-net-provider] VISTA Embedded Problem
Jiri, I installed it on XP and installed it with the same normal user that failed in VISTA. Everything worked as expected. Something in VISTA is causing the problem. I love Micro$oft :( Thanks for you interest -- and all the work you do on the Provider. Marv On 8/4/07, Jiri Cincura [EMAIL PROTECTED] wrote: On 8/5/07, Marvin Cook [EMAIL PROTECTED] wrote: Jiri, The fbembed.dll is in the executable folder and I am using the new ClientLibrary connection string builder data element to point to it. Works fine if my development account runs it. With a regular user, the program throws an exception. The details are: ** Exception Text ** FirebirdSql.Data.FirebirdClient.FbException: operating system directive CreateFileMapping failed --- This could be a hint. I've never has this environment, so I have no deep detail. -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - 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