Re: [Firebird-net-provider] Executing Stored Procedure

2006-04-04 Thread Jiri Cincura
On 4.4.2006 17:56 Charles Urbina wrote: Jiri, This is great information which I will also need. But what I want is a Sample code of how do you configure the Provider to send the stores procedure params and get the result displayed on a dataview. Hi, it's same like the "normal" select. Try t

Re: [Firebird-net-provider] RE: Feedback request

2006-04-04 Thread Carlos Guzmán Álvarez
Hello: I have not used ADO with other databases - so I have a question to this.. This "always-true feature" was designed in the .NET Framework and e.g. SqlDataReader.HasRows works the same (strange) way or this is FBProvider specific behaviour (even though it is considered as "not bug")? I simply

[Firebird-net-provider] RE: Feedback request

2006-04-04 Thread marzena
> The best will be to use the DDEX provider to get the Visual Studio=20 > Integration of the provider. Yes - when I was answering your previous mail I realized this too.. However it doesn't work for me yet :-( > > > First - property FbDataReader.HasRows returns always true. > Oops - I hav= > e

[Firebird-net-provider] Fwd: VS 2005 beta 2 and Firebird .net Provider 1.7.1

2006-04-04 Thread José Macoola Cossa
Please, I am using VS 2005 Beta 2.Because I was getting erros of 'Dispose' problems with fbDataAdapter when using fb .net provider 2 RC1, I decided to compile the sources that comes with Firebird .net provider 1.7.1realesed this week, using Nant. It's working.I would like to know if it there is any

Re: [Firebird-net-provider] 2.0 Provider and 2.0 RC1 Database

2006-04-04 Thread Carlos Guzmán Álvarez
Hello: I have been using the Firebird-net-provider 1.7 and the 1.5 embedded database inside Visual Studio 2005 with a Forms Application, it work fine. I switched to the 2.0 .NET Provider using the 1.5 embedded database and it works as well. But when I switched to 2.0 .NET Provider and 2.0 RC1

Re: [Firebird-net-provider] Executing Stored Procedure

2006-04-04 Thread Charles Urbina
Jiri, This is great information which I will also need. But what I want is a Sample code of how do you configure the Provider to send the stores procedure params and get the result displayed on a dataview.   Tia Charles     From:  Jiri Cincura <[EMAIL PROTECTED]>Reply-To:  firebird-net-provide

Re: [Firebird-net-provider] Executing Stored Procedure

2006-04-04 Thread Jiri Cincura
On 4.4.2006 15:28 Charles Urbina wrote: Hello Everyone. I would like someone in this list if you could provide some sample code of how to execute a stored procedure that returns a result into a datagrid. (WebForm) I'm using VS 2005 and Firebird 1.5 If it returns result, just use ExecuteSca

Re: [Firebird-net-provider] Re: Connection Pooling Problem

2006-04-04 Thread Eric Walmsley
Hi, Thanks for this ... I'll give it a try. Eric sasha wrote: There were a few bugs in Provider in connection pooling. We fixed them and sent bugreports to Carlos. But i don't know if he commit fixes in 1.7.1 or not. You can rebuild provider yourself with our fixes. Replace original FB

Re: [Firebird-net-provider] Connection Pooling Problem

2006-04-04 Thread Eric Walmsley
Hi,  I did have Pooling=true when I ran the example and got the 10 connections. If I disable Pooling, then everything works, but the app runs a lot slower. Cheers Eric Carlos Guzmán Álvarez wrote: Hello: This connection string has pooling disabled ... I will try to make a tes

[Firebird-net-provider] Executing Stored Procedure

2006-04-04 Thread Charles Urbina
Hello Everyone. I would like someone in this list if you could provide some sample code of how to execute a stored procedure that returns a result into a datagrid. (WebForm) I'm using VS 2005 and Firebird 1.5   Tia Charles   --- This SF.Net ema

[Firebird-net-provider] Re: SQLMonitor

2006-04-04 Thread Dimyan
Carlos Guzmán Álvarez пишет: Hello: Does SQLMonitor for Firebird ADO.NET Data Provider 2.0 exist? No. And how can I view to the sending sql-queries? --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that ext

Re: [Firebird-net-provider] Connection Pooling Problem

2006-04-04 Thread Carlos Guzmán Álvarez
Hello: value="User=SYSDBA;Password=masterkey;Database=C:\ChARMTeamData\ChARM.fdb;DataSource=localhost;Charset=NONE;Pooling=false;MinPoolSize=10;MaxPoolSize=200;Connection Lifetime=5;ServerType=0" /> This connection string has pooling disabled ... I will try to make a test to see if there any pro

Re: [Firebird-net-provider] Re: SQLMonitor

2006-04-04 Thread Carlos Guzmán Álvarez
Hello: And how can I view to the sending sql-queries? The provider has nothing to do that so you will need to do it manually. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored by xPML,

Re: [Firebird-net-provider] SQLMonitor

2006-04-04 Thread Carlos Guzmán Álvarez
Hello: Does SQLMonitor for Firebird ADO.NET Data Provider 2.0 exist? No. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends appli

[Firebird-net-provider] Re: Firebird-net-provider digest, Vol 1 #1186 - 10 msgs

2006-04-04 Thread Carlos Guzmán Álvarez
Hello: my answers are written within the original text.. Thanks. :) When I change FbDataAdapter - e.g. I change select query - I can only generate NEW Dataset. There is no way of updating my existing Dataset.. This behaviour is unpleasant because in the time of updating DataAdapter I usually ha

[Firebird-net-provider] Re: Connection Pooling Problem

2006-04-04 Thread sasha
There were a few bugs in Provider in connection pooling. We fixed them and sent bugreports to Carlos. But i don't know if he commit fixes in 1.7.1 or not. You can rebuild provider yourself with our fixes. Replace original FBConnectionPool.cs file from attachment. /* * Firebird ADO.NET Da