[Firebird-net-provider] Exception using AspNet.Identity

Hi all I have ported an application (MVC5, SQLServer) to Firebird but i notice some exceptions in debug mode (tried fb 4.7 and fb 4.8 provider). This app is using AspNet.Identity to authenticate users. With SQLServer i didn't get this exception: An exception of type 'FirebirdSql.Data.FirebirdCl

Re: [Firebird-net-provider] Make FbNetProvider classes unseal

On 2015.01.16 12:02 PM, Lukáš Vykydal wrote: > We d'like to monitor performance (time to execute) for every statement. > > We have a lot of code which use only base ADO.NET access to database. > With this change we can find "performance killers" in this code more > easly including parameters and pl

Re: [Firebird-net-provider] EF Migrations

On 2014.11.06 3:06 PM, Jiří Činčura wrote: > Hi *, > > Anybody here willing to give EF Migrations a try? I'm getting close to first > implementation. > First error i got when i enable migrations: "Checking if the context targets an existing database... No MigrationSqlGenerator found for provider

Re: [Firebird-net-provider] Firebird and VS 2015 preview

On 2015.01.08 11:04 PM, Jiří Činčura wrote: > You mean DDEX? > Yes Jiri, you are right. I modified reg files(12.0_config->14.0_config) and is working. Thanks. Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___ ---

[Firebird-net-provider] [FB-Tracker] Created: (DNET-584) Add suport for Firebird 3

Environment: Windows 8.1 x64, Windows 10 x64, Firebird 3 beta 1 Reporter: Mercea Paul Assignee: Jiri Cincura Priority: Minor I'm trying to test an existing app with next Firebird 3 version but i get error message: "Could not retrieve stora

[Firebird-net-provider] Firebird and VS 2015 preview

Hi all Has anyone tried Firebird with Visual Studio 2015 preview? Is enough to modify reg files to register as provider? TIA, Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___ --

Re: [Firebird-net-provider] Insert into uncommitted table

On 2014.12.22 2:08 PM, Jiří Činčura wrote: > Hi *, > > Anybody knows a trick how to insert into freshly created table without > commiting that DDL first. It's kind of fucking up first migration. :) > > Basically: > Start TX. >Create table. >Insert into table. > Commit TX. > Hi Jiri Someth

Re: [Firebird-net-provider] EF Migrations

On 2014.11.06 3:06 PM, Jiří Činčura wrote: > Hi *, > > Anybody here willing to give EF Migrations a try? I'm getting close to first > implementation. > I'm trying to add support for Firebird db for existing app on SQL Express, and, first run of the application was with no errors and created the

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-571) Firebird DDEX Provider Visual Studio 2013 SP3 - Connection dialog disappears immediately

On 2014.10.15 2:31 PM, Wolfgang Lemmermeyer wrote: > > > > there are more than one Entry for the Firebird Client: > invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework > Data Provider for Firebird" > type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, > Firebir

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-571) Firebird DDEX Provider Visual Studio 2013 SP3 - Connection dialog disappears immediately

On 2014.10.15 2:02 PM, Jens Warkentin (JIRA) wrote: > Firebird DDEX Provider Visual Studio 2013 SP3 - Connection dialog disappears > immediately > > > Key: DNET-571 > URL: h

Re: [Firebird-net-provider] EF Migrations

On 2014.11.06 3:06 PM, Jiří Činčura wrote: > Hi *, > > Anybody here willing to give EF Migrations a try? I'm getting close to first > implementation. > I'm in. Paul MERCEA ___ --

Re: [Firebird-net-provider] Detect current connection is local or network

On 12/16/2013 10:15 AM, Mr. John wrote: Hi, but how to detect app is running on server side or on local,I used to search for firebird process but I found as I said, fb was installed also on client side,so the trusted point to get that info is from firbird connection thanks. Check table MON

Re: [Firebird-net-provider] Detect current connection is local or network

On 12/16/2013 08:34 AM, Mr. John wrote: That I also do, but I only apply database update scripts on server machine,also some users using default app installer installed also FB server on 'client' side. I also want to warn about that. thanks Increment application version on server side, as fi

Re: [Firebird-net-provider] Detect current connection is local or network

On 12/15/2013 12:21 PM, Mr. John wrote: Hi When using my application over a network,only when it is update on the server machine,client applications must download also the update so I need to detect server or client state thanks Hi If you separate the client and the server, even if you work on

Re: [Firebird-net-provider] Migrations

On 2013.04.20 9:18 AM, Jiri Cincura wrote: > Hi *, > > is there an interest in Migrations provider (for EF) for Firebird? Hi Jiri It could be a good improvement to provider. I think is necessary to take care about 255 DDL metadata changes allowed per table. Regards -- Paul MERCEA _

Re: [Firebird-net-provider] Exception using Firebird .NET provider and SimpleMembershipProvider in MVC4

Hi Markus On 2013.02.27 4:33 PM, Markus Ostenried wrote: > Hi all, > > I've been using Firebird with Delphi for many years, wrote a few .NET > applications and have experience in web development. > However: I never did web development with .NET and my only experience > with the Firebird .NET provi

Re: [Firebird-net-provider] Error creating data model

On 2012.09.21 11:47 AM, Jiri Cincura wrote: > Are you sure you're connecting to same database? > Hi Jiri Checked again...Yes, is the same database (using alias from alias.conf). I have tried with a new one as well, same story, work in VS2012, i get error in VS2010. Regards, Paul -

[Firebird-net-provider] Error creating data model

Hi all Using Windows 7 professional x64, Firebird 2.5.1, Firebird.Net provider 2.7.7, Visual Studio 2012 (and 2012). Registered Firebird DDEX and modified machine.config (same as old laptop). In VS 2010 i'm trying to create a new ADO.Net Entity Data Model. In UI i select to generate from databas

[Firebird-net-provider] How to use SimpleMembershipProvider with Firebird?

Hi all With the new ASP.NET MVC4 default template we have SimpleMembershipProvider. This is not working with FirebirdSQL.Web.Provider. How to configure or what can be done to work with existing database? TIA, Paul -- L

Re: [Firebird-net-provider] Releasing more often???

On 2012.07.26 1:16 PM, Jiri Cincura wrote: Hi *, I don't like the idea of huge releases with bumping version number from 1.3 to 12.87 :). Especially because we're open source, I'd like to release more often [1] - you'll get the bug fix faster. You can test features faster/earlier. I more (or le

Re: [Firebird-net-provider] Failed to Add Relation(s)

On 2012.06.21 10:44 AM, Sener DEMIRAL wrote: > CREATE TABLE AAA ( > A1PK INTEGER NOT NULL, > A2INTEGER, > A3INTEGER > ); > ALTER TABLE AAA ADD CONSTRAINT PK_AAA PRIMARY KEY (A1PK); > > CREATE TABLE BBB ( > B1PK INTEGER NOT NULL, > A1PK INTEGER NOT NULL, > B2

Re: [Firebird-net-provider] Database triggers

Hi Jiri Second vote to put in Open method. As i remember well there is a option on restore proces to start without activating database triggers. On 2012.04.11 11:42 AM, Jiri Cincura wrote: > Hi *, > > I started working on option to disable database triggers (DNET-312) > when connecting to datab

[Firebird-net-provider] NuGET package for FirebirdSql.Web.Provider

Hi Can be made nuget package for FirebirdSql.Web.Provider similar to FirebirdSql.Data.FirebirdClient? It would be useful and comfortable . Regards, -- Mercea Paul E-mail: paul.mer...@almexa.ro

[Firebird-net-provider] [FB-Tracker] Created: (DNET-402) Use DataDirectory for client library

Affects Versions: 2.5.1 Reporter: Mercea Paul Assignee: Jiri Cincura Priority: Minor In FbConnectionStrings.cs change the property public string ClientLibrary { get { return this.GetString("client li

Re: [Firebird-net-provider] SPAM-LOW: Re: Asp.Net MVC - Log in failure with FbMembership

On 2011.09.15 9:05 PM, Jiri Cincura wrote: Where should I look ? Check whether some exception was thrown. I have found the problem! Authentication is working only with users that have password format in clear. All users with "Hashed" password format gets the error message : Login was unsucc

Re: [Firebird-net-provider] SPAM-LOW: Re: Asp.Net MVC - Log in failure with FbMembership

On 2011.09.15 9:05 PM, Jiri Cincura wrote: > Check whether some exception was thrown. > Hi Jiri There's no exception. In debug on Account controler after line if (Membership.ValidateUser(model.UserName, model.Password)) is a salt directly to else ValidateUser method doesn't return any except

[Firebird-net-provider] Asp.Net MVC - Log in failure with FbMembership

Hi I'm developing new web app on ASP.Net MVC3, Fb 2.5, NetProvider 2.6.5, web provider 2.6, machine is Windows 7 Professional x64. I have set membership in web.config as : connectionStringName="cs_FB" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="

Re: [Firebird-net-provider] SPAM-LOW: .NET Framework versions

upport for .NET 2. Is still used by many users. I don't know on Mono if all feature are ported but .NET 2 is fully supported. Best regards -- Mercea Paul ___ -- FREE DOWN

Re: [Firebird-net-provider] SPAM-LOW: Re: Using FBEmbeded in ASP.NET

On 2011.01.11 10:18 AM, Jiri Cincura wrote: > On Mon, Jan 10, 2011 at 21:35, Mercea Paul wrote: >> fbembed.dll is in \bin directory of the published site, but i get error. >> I'll try again this week! > In ASP.NET it's worker process' location what matters.

Re: [Firebird-net-provider] SPAM-LOW: Re: FBSecurity UserPassword

tionality for yout utility program! Check Firebird_v2.5.0.ReleaseNotes.pdf on page 45 ! Regards, Mercea Paul -- Gaining the trust of online customers is vital for the success of any company that requires sensitive d

Re: [Firebird-net-provider] SPAM-LOW: Re: Using FBEmbeded in ASP.NET

Hi Jiri > Why not to place fbembed.dll to place where your application is? The > system will load it for you, even without using ClientLibrary. > fbembed.dll is in \bin directory of the published site, but i get error. I'll try again this week! Regard

[Firebird-net-provider] Using FBEmbeded in ASP.NET

specify the clientlibrary but now I have a solution that can be installed in different locations. How can I use the |DataDirectory| or other locations to get the fbembed.dll ??? -- Regards, Mercea Paul -- Gaining the

Re: [Firebird-net-provider] problem with a query (maybe a bug)

On 2010.04.29 5:06 PM, André Knappstein, Controlling wrote: > k> select userinfo0_.id as x0_0_ > k> from user_infos userinfo0_ > k> where (@p0 in(select views1_.View_Id from User_Views_Map views1_ > k> where userinfo0_.id=views1_.User_Id)) > try this select userinfo0_.id as x0_0_ from user

Re: [Firebird-net-provider] IntPtr and SafeHandle

Hi Jiri Could this cause the "not shooting down" application using embedded database ? As I know that was caused by pooling ! Regards, Paul -Original Message- From: Jiri Cincura [mailto:disk...@cincura.net] Sent: Tuesday, April 06, 2010 11:16 PM To: For users and developers of the Fireb

Re: [Firebird-net-provider] Connection error using Virtual PC Windows XP Mode

On 2010.02.16 6:03 PM, Radwan Khershif wrote: I am using VS 2008 pro, Windows 7, .NET 3.5 SP1 and FbClient 2.5.1 to develop Windows Forms apps. When testing a project using Virtual PC Windows XP mode I get the exception "Array Index was out of bounds" each time I try to connect to the server

[Firebird-net-provider] sql files for web provider

Hi I'm looking for sql files for Membership (used by FirebirdSql.Web.Provider), to download and apply to some databases, but there-s no link for that.I'm lucky to have these files on my pen drive, but others without access to sourcer though svn can't find these files! Can be set a link to sql fi

Re: [Firebird-net-provider] Character set problem between with Firebird & .NET provider

Hi Louis > -Original Message- > From: Louis van Alphen [mailto:lo...@nucleo.co.za] > Sent: Friday, January 08, 2010 14:59 > To: firebird-net-provider@lists.sourceforge.net > Subject: Re: [Firebird-net-provider] Character set problem between with > Firebird & .NET provider > > I still get

Re: [Firebird-net-provider] VS2010 dat providers

> > The problem is, that 1) we have couple of DDEX readme files and 2) > people are simply NOT reading the content carefully. If you look at > DDEX questions from last year, the questioner is doing everything else > but not what's IN readme. > [PM] Can't be done an installer with checkboxes for V

Re: [Firebird-net-provider] Entity Framework, Firebird and Guid

> > Firebird doesn't have direct support for guids. > > Not native in Firebird but maybe with your Provider. By using > "smallint_bool" in the ssdl i can use boolean in entities which isn't > supported too. When i follow your advise from here >

Re: [Firebird-net-provider] how to get started...

> Anyone know if it is possible to update the web page that has v2.0.1 > to have a link to let folks know there is a newer version out there? > It would have been nice to find the correct version yesterday. > > Sam [PM] I don't know if Jiri can correct this but I'm sure someone will. Regards

Re: [Firebird-net-provider] how to get started...

Hi Sam I think you need to configure your machine.config . Read the readme.txt file from FirebirdClientDDex Regards, Paul > -Original Message- > From: Sam Carleton [mailto:scarle...@miltonstreet.com] > Sent: Tuesday, May 12, 2009 02:58 > To: firebird-net-provider@lists.sourceforge.net

Re: [Firebird-net-provider] New version of provider breaks batch execution

Hi Jiri > > The 2.5 isn't 100% backward compatible with 2.1. Hence you have to > rebuild the application too. In fact there's so much changes, both > internally and externaly, that's pure craziness to deploy new > FirebirdClient without testing. ;) > I'm testing my apps...but the end user could

[Firebird-net-provider] New version of provider breaks batch execution

Hi Using Fb 1.5, 2.1 , VS 2005, 2008, IbExpert. I'm deploying updates for my applications as installer for exe's and patches for database. The installer contains and deploy the same 'old' FirebirdSql.Data.FirebirdClient.dll 682 KB (698,880 bytes) in same directory as my exe's. Every thing was fi

Re: [Firebird-net-provider] [SPAM] Re: =?ISO-8859-2?Q?can not use

> First > i put this files > FirebirdSql.Data.Firebird.dll > fbembed.dll - FB1.5.5 > > in "/bin" dir - the same error > i try move this files up to "/" dir > and problem is the same - i miss some files? > > becaouse of problem with FB1.5 > i try with FB2.1 > i copy > FirebirdSql.Data.FirebirdCl

[Firebird-net-provider] Deployment issue/maintenance issue

Hi * Maintaining my application up to date suppose to maintain all components up to date (Fb server (2.1.0->2.1.2), Windows updates,repots, sql files, etc). Including last FB .Net Provider generate new issue for end user.she/he need to install .Net Framework 3.5 because Fb.Net Provider include Ent

Re: [Firebird-net-provider] Instalation error message for Beta 2

ards, Paul > -Original Message- > From: Jiri Cincura [mailto:disk...@cincura.net] > Sent: Monday, April 06, 2009 21:48 > To: For users and developers of the Firebird .NET providers > Subject: Re: [Firebird-net-provider] Instalation error message for Beta > 2 > > On Mon,

Re: [Firebird-net-provider] Instalation error message for Beta 2

> Is the D: drive a network drive? [PM] :D Of course...I launched D:\Downloads\FirebirdClient-2.5.0-Beta2.msi if you want some screen capture... -- This SF.net email is sponsored by: High Quality Requirements in

[Firebird-net-provider] Instalation error message for Beta 2

Hi Jiri I try to install Fb client beta 2 and after copying files, when the status is : Registering product a Message box popup with the message: A network error occurred while attempting to read from file: D:\Downloads\FirebirdClient-2.5.0-Alpha2.msi After that another one with message: The in

Re: [Firebird-net-provider] How to configure provider for Entity

> Do you have proper path in registry for the > FirebirdSql.VisualStudio.DataTools.dll file? [PM] I see all my tables after clicking OK and Finish. The path are ok!and it was ok, but was not working until I added again FirebirdSql.Data.FirebirdClient.dll to GAC!

[Firebird-net-provider] [FB-Tracker] Created: (DNET-219) Port number keyword not supported in entity connection

: Entity Framework support Affects Versions: 2.5.0 Beta 1 Environment: Fb.Net 2.5 Reporter: Mercea Paul Assignee: Jiri Cincura If I set in my connection string port number I get error message: Keyword not supported: 'port number'. I get same error me

Re: [Firebird-net-provider] How to configure provider for Entity

Hi Jiri > The DDEX installation isn't correct. You have to install DDEX with 2.5 > version (check the version you're declaring). [PM] I have solved this issue...problem is that is necesary to uninstall from GAC any previous client and add new one. After these operations I have Firebir in that li

Re: [Firebird-net-provider] OT: Firebirdtutorial etc.

Hi Jiri and * As I remember there is an intention to create a wiki for firebird (see http://wiki.firebirdsql.org/) That could be used for what you wantif suports multi language! Regards, Paul > -Original Message- > From: Jiri Cincura [mailto:disk...@cincura.net] > Sent: Tuesday, Marc

Re: [Firebird-net-provider] How to configure provider for Entity

s > Subject: Re: [Firebird-net-provider] How to configure provider for > Entity > > On Thu, Apr 2, 2009 at 16:34, Mercea Paul > wrote: > > How should I configure FB.Net provider to have entries in "New > connection" > > window? > > > -- > J

[Firebird-net-provider] How to configure provider for Entity

Hi I try to configure new workstation to work with VS 2008, FB2.1/FB2.5 for development. The project will use .Net Entity .. FB and SQL. For SQL server.everything work ok. Primary development database is FB and for this is intended to make the model. So.I add new Ado.Net Entity Data Model, click

Re: [Firebird-net-provider] [SPAM] RE: Want to run 'gbak.exe' from

Hi Don't you have forget to specify servername in cs? Regards, Paul > -Original Message- > From: Rolf Marsh [mailto:rmma...@fastmail.us] > Sent: Friday, March 13, 2009 15:00 > To: firebird-net-provider@lists.sourceforge.net > Subject: Re: [Firebird-net-provider] [SPAM] RE: Want to run 'g

Re: [Firebird-net-provider] Charset problems

Hi I think you could use 2 solution: 1. you could add charset to your connection string: FbConnectionStringBuilder fbcs = new FbConnectionStringBuilder(); fbcs.Database = @"C:\Data\myDb.fdb"; fbcs.Charset = "NONE"; <- put your charset... .

Re: [Firebird-net-provider] GUID handling (CHAR (16) OCTETS)

Hi Zoltan I', agree with you! >Not the text representation. The Microsoft GUID internal structure different >from FB's. This causes different byte order of the structs members. >This situation also happens in C or C++ using IBPP. >The problem is the different internal representation of the gui

[Firebird-net-provider] [FB-Tracker] Created: (DNET-216) New property in connection string builder - Trusted authentication

: New Feature Components: ADO.NET Provider Environment: Windox XP Firebird 2.5 Reporter: Mercea Paul Assignee: Jiri Cincura Priority: Minor Scenario: I'm authenticated as a simple user in Windows and I get some problems in my app develop

Re: [Firebird-net-provider] GUID handling (CHAR (16) OCTETS)

Hi Zoltan I have had same problem... Try to insert guid as char, don’t convert to guid. INSERT INTO T(G) VALUES('12345678-1234-1234-1234-123456789ABC'); >INSERT INTO T(G) VALUES(CHAR_TO_UUID('12345678-1234-1234-1234-123456789ABC')); >SELECT UUID_TO_CHAR(G) FROM T; >Result: '12345678-1234-1234-12

[Firebird-net-provider] [SPAM] RE: [SPAM] RE: Want to run 'gbak.exe' from within

] [SPAM] RE: Want to run 'gbak.exe' from within Hi Paul... I still get the following error message: Cannot attach to services manager service localhost:service_mgr is not defined How do I fix this? Mercea Paul wrote: Hi Take a look at my code: private void btnBackUp_Cl

[Firebird-net-provider] [SPAM] RE: [SPAM] RE: [SPAM] RE: Want to run 'gbak.exe' from within

Hi Rolf, Here is the example I am using... FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); cs.DataSource = "localhost"; cs.UserID = "SYSDBA"; cs.Password = "masterkey"; cs.Database = "dbBooks"; [PM] If dbBooks is

[Firebird-net-provider] [SPAM] RE: [SPAM] RE: Want to run 'gbak.exe' from within

] [SPAM] RE: Want to run 'gbak.exe' from within Hi Paul... I still get the following error message: Cannot attach to services manager service localhost:service_mgr is not defined How do I fix this? Mercea

[Firebird-net-provider] [SPAM] RE: Want to run 'gbak.exe' from within

Hi Take a look at my code: private void btnBackUp_Click(object sender, EventArgs e) { //backup with service FbBackup fbbsvc = new FbBackup(); fbbsvc.ConnectionString = Properties.Settings.Default.AppConnStr; //take backu

[Firebird-net-provider] Same user id have diferent value in membership and uuid_to_char ()

Hi all FB2.1 and FB.Net provider 2.5. I'm porting a web app to win app and I found a difference between readable id of user from membership and readable id of user from users table. I have this code: Variables.UserId = Membership.GetUser(Variables.UserName).ProviderUserKey.ToString(); That retu

Re: [Firebird-net-provider] Fw: Connetion pooling problem

et=NONE;initial catalog=database.FDB;user id=SYSDBA;password=pass;data source=localhost" I use Firebird .net provider 2.5.0.0, IIS 6 and win server2003 There is only this application on this server. _____ From: Mercea Paul To: For users and developers of the Firebird .NET provid

Re: [Firebird-net-provider] Fw: Connetion pooling problem

Hi Ali How is your connection string looks like? Pooling is set to true ? Regards, Paul From: Ali Erdogan [mailto:allierdo...@yahoo.com] Sent: Thursday, February 05, 2009 16:01 To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Fw: Connetion pooling p

Re: [Firebird-net-provider] Programs refuse to run with new dll 2.5.0.0 beta

> Do you have empty username and password? If so, then FirebirdClient is > trying to use trusted auth to server. [PM] As I see in code, is empty, because I use embeded FB . fbcs.ClientLibrary = apppath + @"\fb\fbembed.dll"; fbcs.Dialect = 3; fbcs.Pooling = f

[Firebird-net-provider] Programs refuse to run with new dll 2.5.0.0 beta

Hi all Using FB 2.1.0.17798 embedded . I have downloaded FirebirdSql.Data.FirebirdClient-2.5.0-Beta1 and put the dll in gac (2.5.0.0) I have tried to run some programs compiled with previous version of .Net provider but refuse to run with no error message, just crash. I wonder if other users ge

Re: [Firebird-net-provider] log filled with INET error 10054

> OK I'm not so lucky. :) The problem is in connection pooling that was > turned off on my connection string. I'll look at the problem. [PM] This error is related to http://tracker.firebirdsql.org/browse/DNET-156 to or is something new? Regards, Paul ---

Re: [Firebird-net-provider] How to stop all other database connections

> hello > > i want to add some functionality to our application which will allow a user > to alter the metadata of the database. before this happens i want to run > some code which will ensure that all other users have been kicked out and > are no longer accessing the Firebird 2.1 db. i was wonder

Re: [Firebird-net-provider] FbScript should have a constructor with string Script

> -Original Message- > From: Pham Huu Le Quoc Phuc [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 14, 2008 13:05 > To: 'For users and developers of the Firebird .NET providers' > Subject: [Firebird-net-provider] FbScript should have a constructor with > string Script > > Dear all, >

Re: [Firebird-net-provider] ExecuteReader is slow

From: giorgi giorgi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2008 12:23 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] ExecuteReader is slow Running a recursive cte against a table with about 1600 rows from my program needs

Re: [Firebird-net-provider] ExecuteReader is slow

arameters are added during runtime. When I call ExecuteReader it takes too much time, about 0.028 seconds. On Mon, Sep 29, 2008 at 9:18 PM, Mercea Paul <[EMAIL PROTECTED]> wrote [PM] First: if database is on Windows change database name from name.gdb to name.fdb or something differ

Re: [Firebird-net-provider] ExecuteReader is slow

Maybe you should change this to a stored procedure and pass parameters … should run more faster then your code! From: giorgi giorgi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2008 10:24 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provi

Re: [Firebird-net-provider] ExecuteReader is slow

> -Original Message- > From: Steve Faleiro [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 30, 2008 11:29 > To: For users and developers of the Firebird .NET providers > Subject: Re: [Firebird-net-provider] ExecuteReader is slow > > > 1. Did you try to optimize the query? I know F

Re: [Firebird-net-provider] ExecuteReader is slow

giorgi giorgi wrote: > Hello, > > I am developing an application that uses firebird database and I use > firebird provider for ado.net The application makes > many calls to ExecuteCommand method of FbCommandClass. According to .net > performance provider it is the slowest metho

Re: [Firebird-net-provider] .NET 2.0 Provider on PokcetPC connect error

> > always have this exception, 'No message for error code 335544721 found'. > > this is my code > > It's Unable to complete network request > to host "". [PM] See if 3050 port is not blocked by firewall on host! Regards, Paul -

Re: [Firebird-net-provider] Server Engine`?

Hi Sven Are you talking about n-tier application? In that scenario each client connect to a 'server service' which communicate with database! Regards, Paul > -Original Message- > From: Sven [mailto:[EMAIL PROTECTED] > Sent: Friday, October 03, 2008 09:25 > To: firebird-net-provider@lists

Re: [Firebird-net-provider] Problems with parametrized queries (DDEX VS2008)

Could you show the code that execute this sql query? > -Original Message- > From: Zento [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 02, 2008 12:02 > To: firebird-net-provider@lists.sourceforge.net > Subject: [Firebird-net-provider] Problems with parametrized queries (DDEX > VS2008

Re: [Firebird-net-provider] ExecuteReader is slow

Here is source code: FbCommand cmd = BuildCommand(DbCommand); cmd.Parameters.AddWithValue("@from", From); cmd.Parameters.AddWithValue("@to", To); cmd.Parameters.AddWithValue("@code", Code); try { cmd.Connection.Open(); //This needs 0.028 seconds. return cmd.ExecuteReader(CommandBehavior

Re: [Firebird-net-provider] ExecuteReader is slow

From: giorgi giorgi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2008 12:02 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] ExecuteReader is slow 1. I changed query but ut's the same. 2. Yes, there are ascending indexes. 3.

Re: [Firebird-net-provider] ExecuteReader is slow

From: giorgi giorgi [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2008 12:53 To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] ExecuteReader is slow Hello, I am developing an application that uses firebird database and I use firebird provider for

Re: [Firebird-net-provider] Memory leak in ASP.NET pages showing

> Sorry about that. On XP, the process is named "aspnet_wp.exe" and on > Windows Server 2003 it is "w3wp.exe". Basically it is the task > handling the > ASP.NET. However, it only happens when I access the firebird database. > [PM] Can you try to open your connection before execution and clos

Re: [Firebird-net-provider] Memory leak in ASP.NET pages showing a gridView accessing FirebirdSql.Data.FirebirdClient.dll

> I have a memory leak issue. I have two ASP.NET pages that just have a > timer > that updates a label. One page also has a gridView that shows a little > data. > > The page with just the label stays at a set memory usage. The page > with the > GridView keeps slowly taking more and more memory.

Re: [Firebird-net-provider] Firebird embedded(ver 2.1) 64 bit support with DotNetFirebird client

> -Original Message- > From: Dean Harding [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 23, 2008 10:31 AM > To: For users and developers of the Firebird .NET providers > Subject: Re: [Firebird-net-provider] Firebird embedded(ver 2.1) 64 bit > support with DotNetFirebird client > >

Re: [Firebird-net-provider] Creating a Database using ADO.Net Data Provider For Firebird

Hi I'm using this: #region ConnectionString /// ///Connection String /// FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); cs.UserID = "USERDB"; cs.Password = "userdb";

Re: [Firebird-net-provider] FbDataConnectionUIControl

Hi Ulrich, Have you register your database in VS Server Explorer? If you do..on right click on registered database you can Modify Connection ... is the same window as displayed for connection string for fbconnection and for adding new connection for database in Server Explorer! Regards, Paul > -

Re: [Firebird-net-provider] Sample project for Fb.Net Provider

This is a good start. I've missed the 'IDEA' from there..:) From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mercea Paul Sent: Wednesday, September 17, 2008 10:47 AM To: 'For users and developers of the Firebird .NET providers' Subject: [Firebird-net

[Firebird-net-provider] Sample project for Fb.Net Provider

Hi * I'm asking if is not a good to have a sample project on FB.Net provide page! If is someone interested .. Best regards, Paul - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coole

Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data

nesday, September 17, 2008 9:56 AM > To: For users and developers of the Firebird .NET providers > Subject: Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data > > > --- Mercea Paul <[EMAIL PROTECTED]> wrote: > > > On http://firebirdsql.org/index.php?op=fil

Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data

On http://firebirdsql.org/index.php?op=files&id=netprovider you'll find all you need! By the way... my fbconnection.connection string property has no ... button , but I don't use this visual component, I have declared in my db class and build the connection string ... I think this is the most used

Re: [Firebird-net-provider] install ddex 2.0.3 in vs2008 Team

After install you'll find README.TXT in firebird client ddex folder ! If this not helpful enough ask more help here! Regards, Paul > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Freddy Caballero > Sent: Saturday, September 06, 2008 4:49 AM > To:

Re: [Firebird-net-provider] VS2008 DDEX probem

Could be this a problem related to ADO.Net Entity Framework For 2.5 need some extra dll ??? Regards, Paul > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Christian Nylund > Sent: Friday, September 05, 2008 2:32 PM > To: For users and develope

Re: [Firebird-net-provider] Roadmap

Hi I'm using 2.5 all ready in several projects. As I know, 2.5 will provide .net entity provider ... Do you need something else? Regards, Paul > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Tetram Corp > Sent: Thursday, September 04, 2008 3:16

Re: [Firebird-net-provider] VS2008 DDEX probem

Try with FirebirdDDEXProviderPackageLess32 if you don't have VS SDK installed! Regards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christian Nylund Sent: Thursday, September 04, 2008 11:44 AM To: Firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-pr

Re: [Firebird-net-provider] How / Can i detect the pagesize with fbprovider 2.x?

I think you can try with FbDatabaseInfo.PageSize !!! Regards, Paul > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Michael Möhle > Sent: Wednesday, September 03, 2008 5:51 PM > To: firebird-net-provider@lists.sourceforge.net > Subject: [Firebird-n

Re: [Firebird-net-provider] Help with SQL

d ON (d.InvoiceID = i.InvoiceID) join InvoicePayment p ON (p.InvoiceID = i.InvoiceID) where (i.InvoiceID = :InvoiceID) group by i.SiteID, i.InvoiceID order by i.SiteID, i.InvoiceID Regards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mercea Paul Sent: Wednesday, A

Re: [Firebird-net-provider] Help with SQL

Try this select i.SiteID, i.InvoiceID, Sum(COALESCE(d.Charge, 0)) AS Itm, Sum(COALESCE(p.Amount, 0)) AS Pmt, (Sum(COALESCE(d.Charge, 0)) + SUM(COALESCE(p.Amount, 0))) AS Total from Invoice i join InvoiceDetail d ON (d.InvoiceID = :InvoiceID) join InvoicePayment p ON (p.InvoiceI

Re: [Firebird-net-provider] Firebird .net + ZeBeDee + Events

As I remember you can set the event port in firebird.conf...at least in FB 2.1 # # The TCP Port Number to be used for server Event Notification # messages. The value of 0 (Zero) means that the server will choose # a port number randomly. # # Type: integer # #RemoteAuxPort = 0 Best regards, Paul

Re: [Firebird-net-provider] New in Firebird

There is no logic to do this in one SP.. Select * from DoSomething will return a dataset corresponding for your output parameters! > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Javier Lozano > Sent: Friday, August 01, 2008 8:10 AM > To: firebird-

  1   2   3   >