Re: [Firebird-net-provider] Firebird-net-provider Digest, Vol 6, Issue 11

2006-10-06 Thread Carlos Guzmán Álvarez
Hello: > CHAR value types are for fixed length data fields. If you enter 2 characters > in a 10 character field, the other 8 characters are typically field with > spaces (depends on implementation). All though most developers trim results > of CHAR fields, there are some applications that might

Re: [Firebird-net-provider] Firebird-net-provider Digest, Vol 6, Issue 11

2006-10-06 Thread Steve Ramacher
CHAR value types are for fixed length data fields. If you enter 2 characters in a 10 character field, the other 8 characters are typically field with spaces (depends on implementation). All though most developers trim results of CHAR fields, there are some applications that might require the spa

Re: [Firebird-net-provider] Update parameter without SourceColumn

2006-10-06 Thread Mauricio I. Magni
Great news. Thank you. ""Carlos Guzmán Álvarez"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello: >> Could anybody point me in the right direction? > I will do a change in the provider to avoid processing of parameters = > > without SourceColumn > ( it's something that is bein

Re: [Firebird-net-provider] Update parameter without SourceColumn

2006-10-06 Thread Carlos Guzmán Álvarez
Hello: > Could anybody point me in the right direction? I will do a change in the provider to avoid processing of parameters without SourceColumn ( it's something that is being done yet when processing output parameters ) -- Carlos Guzmán Álvarez Vigo-Spain ---

Re: [Firebird-net-provider] Update parameter without SourceColumn

2006-10-06 Thread Mauricio I. Magni
Hello Marek Thank you for this workaround. I'll try it with delete too. I've sent a test case to Carlos, maybe he can give us a more elegant solution. Maurcio. ""marzena"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi Mauricio, > > Few days ago I got similar exception of ty

Re: [Firebird-net-provider] Lockup Problems

2006-10-06 Thread Jim Maguire
Standalone Not using threads Isolation Level is the default "ReadCommitted" Would AccessMode of "ReadOnly" prevent any chance of deadlocks? ""Carlos Guzmán Álvarez"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello: >> 1. I'm using FB 1.5 with firebird .net data provider 1.

[Firebird-net-provider] Update parameter without SourceColumn

2006-10-06 Thread marzena
Hi Mauricio, Few days ago I got similar exception of type ArgumentNullException. I have found out this conclusion.. Unfortunately the Provider checks whether SourceColumn property is filled with some string and if not it throws an exception. So my solution was very simple - I had mapped my "troub

Re: [Firebird-net-provider] Res: Enc: FB 2.0

2006-10-06 Thread Rick Hoover
Great! Sorry for the previous post... Carlos Guzmán Álvarez wrote: > Hello: >> There was a mistake in my code SQL, then I re-did him and this = > >> working well now. >> >> Thank you very much for your help. > Great ! >> Carlos, where is you from?Brasil? > Spain :) > > > > -- = > > Car

Re: [Firebird-net-provider] FB 2.0

2006-10-06 Thread Rick Hoover
Rodolfo Luiz wrote: > Hello, > > I'm using FB 2.0 RC4, in my applications Win32 with Delphi, I don't have > problem, but now I need to use the FB 2.0 RC 4 with Delphi 2006/ASP.Net > and I am not getting. > > The error message that ASP. Net comes back it is the following: > > > Server Error in

Re: [Firebird-net-provider] Char values trimming

2006-10-06 Thread Rick Hoover
I would concur with Oleg. It is such an easy thing to add the call to the trim function on the application side so that the small gain is outweighed by the hiding of the char value's actual size. So, make that two votes against. Rick On Friday 06 October 2006 08:41, Oleg Deribas wrote: > Hell

Re: [Firebird-net-provider] Char values trimming

2006-10-06 Thread Oleg Deribas
Hello, Carlos Guzmán Álvarez said the following on 06.10.2006 17:36: > I'm thinking on doing a change in the provider to make a trim on char > values returned by selectable commands. I don't think it is good idea. It would just add hidden logic to the provider. If I will need such a behavior -

[Firebird-net-provider] Char values trimming

2006-10-06 Thread Carlos Guzmán Álvarez
Hello: I'm thinking on doing a change in the provider to make a trim on char values returned by selectable commands. Opinions are welcome !!! -- Carlos Guzmán Álvarez Vigo-Spain - Take Surveys. Earn Cash. Influence

Re: [Firebird-net-provider] How to change cache

2006-10-06 Thread Carlos Guzmán Álvarez
Hello: > I will try to change the constructors on that class of the services > implementation that shoduln't be used directly. Forgot it .. hehe .. it's an struct ... ;) -- Carlos Guzmán Álvarez Vigo-Spain - Take Surveys.

Re: [Firebird-net-provider] How to change cache

2006-10-06 Thread Carlos Guzmán Álvarez
Hello: > FbServerConfig config = new FbServerConfig(); > config.DefaultDbCachePages = cachePageNumber; That class is used by the FbServerProperties class, it's not a class to be used directly. I will try to change the constructors on that class of the services implementation that shoduln't be u

Re: [Firebird-net-provider] How to change cache

2006-10-06 Thread firebird tmc
> Hello:> > I need to change cache size of embedded firebird from a configuration => > application (C#). => > The DefaultDbCachePages in firebird.conf file for the embedded DB is => > 6144 originally.  I tried fetching the value by =>> > FbServerConfig.DefaultDbCachePages. It always returns 0, even

Re: [Firebird-net-provider] DDEX, Visual Studio, quoted identifiers

2006-10-06 Thread Carlos Guzmán Álvarez
Hello: > Is there a config switch I have not yet found? > Is this a general problem of Visual Studio or DDEX? I have been checking this a little and i think there ar eno way to configure that ( or i didn't know how ) -- Carlos Guzmán Álvarez Vigo-Spain ---

Re: [Firebird-net-provider] Stored procedure - issue

2006-10-06 Thread Carlos Guzmán Álvarez
Hello: > Here is my stuff calling iBatis: > > Mapper().BeginTransaction(); > return (MyObject) Mapper().QueryForObject ("StoreProcId", id); I haven't IBatis could you check what is the sql command IBatis is executing ?? -- Carlos Guzmán Álvarez Vigo-Spain -

Re: [Firebird-net-provider] Update parameter without SourceColumn

2006-10-06 Thread Carlos Guzmán Álvarez
Hello: > Could anybody point me in the right direction? Could you send to my private email a test case showing the problem ( with a test database if possible ), please ?? -- Carlos Guzmán Álvarez Vigo-Spain - Take Survey

[Firebird-net-provider] TransactionScope support

2006-10-06 Thread Carlos Guzmán Álvarez
Hello: I'm thinking on see how to implement the TrasnactionSCope support in the v2.0 of the provider. Does anybody knows of good article on this subject ?? -- Carlos Guzmán Álvarez Vigo-Spain - Take Surveys. Earn Cash

Re: [Firebird-net-provider] How to change cache size (DefaultDbCachePages)

2006-10-06 Thread Carlos Guzmán Álvarez
Hello: > I need to change cache size of embedded firebird from a configuration > application (C#). > The DefaultDbCachePages in firebird.conf file for the embedded DB is > 6144 originally. I tried fetching the value by > FbServerConfig.DefaultDbCachePages. It always returns 0, even after I >

Re: [Firebird-net-provider] Threading Issue

2006-10-06 Thread Carlos Guzmán Álvarez
Hello: > Since FB 2.0 is not final we probably will keep FB 1.5.3. Most of the > problems got solved by disabling connection pooling in the db connection > string. What still persist is an error saying that 1 transaction is still > active and not commited when con.close() is performed. Does ther

Re: [Firebird-net-provider] Firebird ADO.NET Data Provider

2006-10-06 Thread Carlos Guzmán Álvarez
Hello: > I have some remarks & questions concerning the use of Fb .NET Provider. > > 1) I have installed both Provider and DDEX, so I can browse FB > databases through the Server Explorer in Visual Studio 2005. When > registering an FB database in the Server Explorer I specify either > 'localh

Re: [Firebird-net-provider] Res: Enc: FB 2.0

2006-10-06 Thread Carlos Guzmán Álvarez
Hello: > There was a mistake in my code SQL, then I re-did him and this > working well now. > > Thank you very much for your help. Great ! > Carlos, where is you from?Brasil? Spain :) -- Carlos Guzmán Álvarez Vigo-Spain

[Firebird-net-provider] Res: Enc: FB 2.0

2006-10-06 Thread Rodolfo Luiz
Hi Carlos,There was a mistake in my code SQL,  then I re-did him and this working well now.Thank you very much for your help.Carlos, where is you from?Brasil?RegardsRodolfo Luiz- Mensagem original De: Carlos Guzmán Álvarez <[EMAIL PROTECTED]>Para: For users and developers of the Firebird .N

Re: [Firebird-net-provider] deadlock

2006-10-06 Thread Oleg Deribas
Hello, John Smith said the following on 05.10.2006 21:37: > Ok all of my routines that access the database do call the dispose method. > The problem still seems to exist. There is only 1 database connection to the > database right now but there are multiple threads accessing the Connection. >

Re: [Firebird-net-provider] Enc: FB 2.0

2006-10-06 Thread Carlos Guzmán Álvarez
Hello: > Please check if the query runs on isql, ibpexert or similar. And if it works fine there, please let me know. -- Carlos Guzmán Álvarez Vigo-Spain - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForg