Re: [Firebird-net-provider] Problem when executing ClearAllPool.

2007-04-03 Thread Carlos Guzmán Álvarez
Hello: > Do you call Dispose on FbCommand obejcts when they are no more needed ?? It's possible for you to send a small test case showing the problem ?? - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.

Re: [Firebird-net-provider] Problem when executing ClearAllPool.

2007-04-03 Thread Carlos Guzmán Álvarez
Hello: > I am using Firebird 2.0 for my .Net desktop application. I am What version of the provider are you using ?? > Sequence of my execution: > > Conn.Close() > > Conn.ClearAllPool() Huu it could be a bug in the provider with the Dispose implementation for GC calls. Do you call Disp

[Firebird-net-provider] Does anyone know if the firebird net provider support all interbase releases including interbase 7.5 ?

2007-04-03 Thread Pan Heller-q19230
Hi, Guys Does anyone know if the firebird net provider support all interbase releases including interbase 7.5 ? Thanks in advance Heller - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.ne

[Firebird-net-provider] Problem when executing ClearAllPool.

2007-04-03 Thread Ramprasad Gourishetty
Hi Carlos, This is Ram from ShowingTime, with reference of Ann W. Harrison. I am using Firebird 2.0 for my .Net desktop application. I am experiencing a problem when executing ClearAllPool() statement. Sequence of my execution: Conn.Close() Conn.ClearAllPool() The following error

Re: [Firebird-net-provider] Speed Inserts

2007-04-03 Thread Carlos Guzmán Álvarez
Hello: > Currently I am using plain sql queries. > I have read that parametrized queries are faster, but would they be that > much faster? More than probably yes. > I had a single function for my app to update the db so using plain sql > statements make it easy for me to pass any sql string to

Re: [Firebird-net-provider] Speed Inserts

2007-04-03 Thread Gary Saunders
Currently I am using plain sql queries. I have read that parametrized queries are faster, but would they be that much faster? I had a single function for my app to update the db so using plain sql statements make it easy for me to pass any sql string to the function and update the db. ""Carlos

Re: [Firebird-net-provider] Speed Inserts

2007-04-03 Thread Carlos Guzmán Álvarez
Hello: > insert into records (custid, formname, formID) values (1,"form",2) Are you using plain sql queries or parametrized queries ?? - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay pane

Re: [Firebird-net-provider] Accessing dbfile with ODS 11

2007-04-03 Thread Carlos Guzmán Álvarez
Hello: > Ok, my fault: > my FB server is 1.5... not 2.0 sorry :-) > > but I still don't understand the problem of clrexternalengine > > in fact, i don't understand what is goal of Context servertype It was in use for the external procedure engine implementation for Fyracle. ---

[Firebird-net-provider] Speed Inserts

2007-04-03 Thread Gary Saunders
I am using a loop to insert around 300 records into a database table. The sql insert statement is not complex. insert into records (custid, formname, formID) values (1,"form",2) Where custid is updated in each loop. I am wrapping the whole loop in a transaction and committing after the loop is c

Re: [Firebird-net-provider] Accessing dbfile with ODS 11

2007-04-03 Thread Tetram Corp
Ok, my fault: my FB server is 1.5... not 2.0 sorry :-) but I still don't understand the problem of clrexternalengine in fact, i don't understand what is goal of Context servertype Tetram Corp a écrit : > i'm trying to connect to a db with an ods 11 (FB2.0) but I'v got some > errors i don't unde

[Firebird-net-provider] Accessing dbfile with ODS 11

2007-04-03 Thread Tetram Corp
i'm trying to connect to a db with an ods 11 (FB2.0) but I'v got some errors i don't understand: my connection string is: user=SYSDBA;password=masterkey;database=g:\programmation\media.kit\bdthèque\bin\bd.gdb;datasource=127.0.0.1;port=3050;dialect=3;charset=NONE;connection lifetime=15;pooling=t

[Firebird-net-provider] Commit or Rollback after select ?

2007-04-03 Thread Julien Ferraro
Hi all, It's a question for me since a long time. If I create a transaction and just do select statements in it, I'm sure that I didn't change anything in the database. I never know wich is best at the end of the transaction commit or rollback ? Or is just don't matter ... Can someone give me

Re: [Firebird-net-provider] Unsubscribe

2007-04-03 Thread Matt Emson
AHA, badly laid out web page... big section with subline "The subscribers list is only available to the list administrator", but shoved on the bottom is the unsubscribe section.. LOL. Sorry, and Adeus, M - Original Message - From: "Matt Emson" <[EMAIL PROTECTED]> To: "For users and deve

Re: [Firebird-net-provider] Unsubscribe

2007-04-03 Thread Matt Emson
Okay.. how does one unsubscribe from this list these days? - Original Message - From: "Matt Emson" <[EMAIL PROTECTED]> To: "For users and developers of the Firebird .NET providers" Sent: Tuesday, April 03, 2007 10:49 AM Subject: [Firebird-net-provider] Unsubscribe > Unsubscribe > > Sor

Re: [Firebird-net-provider] Provider hangs

2007-04-03 Thread Carlos Guzmán Álvarez
Hello: > So, what will we do with this? If you have no idea than i can ask advice > from Yemanov or Horsun about this problem. I have done the test using the 2.0 sources and your test case was running fine I will try to check teh change for 1.7

[Firebird-net-provider] Unsubscribe

2007-04-03 Thread Matt Emson
Unsubscribe Sorry if this appears on the list, but the SF page for the list didn't seem to list the unsubscription method, so I'm trying the obvious first.. M - Original Message - From: "sasha" <[EMAIL PROTECTED]> To: Sent: Tuesday, April 03, 2007 10:43 AM Subject: Re: [Firebird-net-

Re: [Firebird-net-provider] Provider hangs

2007-04-03 Thread sasha
Or maybe i made something wrong when built provider. FirebirdSql.Data.Firebird.dll was successfully created, but there are an error in NAnt's log file. This is my build log: NAnt 0.85 (Build 0.85.2478.0; release; 14.1

Re: [Firebird-net-provider] Provider hangs

2007-04-03 Thread sasha
> application (same as i sent to you) still hangs with your fixes :-( So, what will we do with this? If you have no idea than i can ask advice from Yemanov or Horsun about this problem. - Take Surveys. Earn Cash. Influence