Re: [Firebird-net-provider] Prepared Stroed Procs and FbDataReader

2006-01-12 Thread Carlos Guzmán Álvarez
Hello: Huuummm ok i will try review it as soon as possible, what version of the provider are you using ?? IF you are using only Firebird you doens't need to do the Prepare call manually as the provider will do it before the execution ( while obviously this is something that needs review :) )

Re: [Firebird-net-provider] Prepared Stroed Procs and FbDataReader

2006-01-12 Thread Carlos Guzmán Álvarez
Hello: Thanks for the reply, but it is set in the constructor. Huuummm ok i will try review it as soon as possible, what version of the provider are you using ?? IF you are using only Firebird you doens't need to do the Prepare call manually as the provider will do it before the execution ( w

Re: [Firebird-net-provider] Prepared Stroed Procs and FbDataReader

2006-01-12 Thread Arthur R
Oleg V. Paschenko wrote: You should set connection property before prepare a command. Thanks for the reply, but it is set in the constructor. --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? St

RE: [Firebird-net-provider] Prepared Stroed Procs and FbDataReader

2006-01-12 Thread Oleg V. Paschenko
Hi, You should set connection property before prepare a command. Oleg > if (getUserEvents == null) > { > getUserEvents = new FbCommand("GetUsersEvents", connection, > transaction); > getUserEvents.CommandType = CommandType.StoredProcedure; > getUserEvents.Parameters.Add("@InputU

[Firebird-net-provider] Prepared Stroed Procs and FbDataReader

2006-01-12 Thread Arthur R
Hi all, I seem to have a problem with preparing stored procedures that use ExecuteReader and FbDataReader. If Prepare is called on the FbCommand, 0 results are returned by the reader. Commenting out the Prepare call makes it work properly. All prepared stored procedures that don't use Execu