Re: [Firebird-net-provider] how to change parameter prefix

2007-08-27 Thread [EMAIL PROTECTED]
Hello, The problem seems to be not very frequent as I didn't find much one the Internet. It's really weird. The Oracle database provider is by microsoft: http://msdn2.microsoft.com/en-us/library/system.data.oracleclient.oraclecommand.parameters.aspx I couldn't find any nice workaround. May be

Re: [Firebird-net-provider] how to change parameter prefix

2007-08-27 Thread Jiri Cincura
On 8/27/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello, The problem seems to be not very frequent as I didn't find much one the Internet. It's really weird. The Oracle database provider is by microsoft:

Re: [Firebird-net-provider] how to change parameter prefix

2007-08-27 Thread Carlos Guzmán Álvarez
Hello: For this time, it's hardcoded in provider code. The '@' character is default fo ADO.NET classes, so if oracle is using another, it's weird. That isn't 100% true :) Really the parameter prefix is provider dependedant ( depends on the RDBMS ), in the Firebird .NET Provider the @ was

Re: [Firebird-net-provider] how to change parameter prefix

2007-08-27 Thread Jiri Cincura
On 8/27/07, Carlos Guzmán Álvarez [EMAIL PROTECTED] wrote: Hello: For this time, it's hardcoded in provider code. The '@' character is default fo ADO.NET classes, so if oracle is using another, it's weird. That isn't 100% true :) Really the parameter prefix is provider dependedant (

Re: [Firebird-net-provider] Bug? Timeout at CheckMaxPoolSize 2.x

2007-08-27 Thread Jon Ege Ronnenberg
I've a similar problem but increasing the max pool size helped. Not sure why or if is the right thing to do.. Here is some further reading: http://blogs.msdn.com/angelsb/archive/2004/09/20/231963.aspx On 6/3/06, JCardinal [EMAIL PROTECTED] wrote: Will try that and report back, thank you. -

Re: [Firebird-net-provider] how to change parameter prefix

2007-08-27 Thread Jiri Cincura
On 8/27/07, Carlos Guzmán Álvarez [EMAIL PROTECTED] wrote: Maybe we should be supporting : as well as it's supported by firebird if i'm not wrong ( or maybe it's ISQL only i'm not sure ) The ':' is used in procedures, triggers, etc. -- Jiri {x2} Cincura (Microsoft Student Partner)

Re: [Firebird-net-provider] how to change parameter prefix

2007-08-27 Thread Carlos Guzmán Álvarez
Hello: The ':' is used in procedures, triggers, etc. Ok, anyway i didn't want to change that right now :) -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/

Re: [Firebird-net-provider] how to change parameter prefix

2007-08-27 Thread Carlos Guzmán Álvarez
Hello: I need to have the C# .NET 2.0 application that could use both firebird and/or oracle as a database engine. What is the best way to hide the difference in parameter prefix? In firebird it is '@' in oracle it is ':' May be it is possible to explicitly set in firebird provider a

Re: [Firebird-net-provider] Linux

2007-08-27 Thread juliosm
Eduardo-34 wrote: Hello all! Server Linux: Debian 4.0 Firebird 2.0.1 CS Client WXP: FirebirdClient ADO.NET 2.0 Work perfect! Knowing that you are there has made it possible. When I finish testing I will prepar a little HowDo. Thanks Hi Eduardo, Are you using the