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:

[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

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

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:

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

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

[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

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

[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

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)

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

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

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

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

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

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

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