Re: [Firebird-net-provider] Linux
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 firebird dot net provider for compact framework? I'm interested to develop an pocket pc application that access a remote firebird database, so, i'm really interested in your HowTo :) Thanks in advance. Julio -- View this message in context: http://www.nabble.com/Linux-tf4270014.html#a12352297 Sent from the firebird-net-provider mailing list archive at Nabble.com. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to change parameter prefix
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 > prefix to ':'? Can you give more information about how you are using the command classes in both providers ?? Maybe an option to get the parameter prefix from the schema support that is built-in the provider and accesible using FbConnection.GetSchema ?? ( I think the oracle provider should have that as well using the DataSourceInformation metadata collection ) -- Carlos Guzmán Álvarez Vigo-Spain Blog: http://carlosga.wordpress.com/ FirebirdClient : http://www.firebirdsql.org/ XMPP Client : http://code.google.com/p/xmppclient/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to change parameter prefix
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/ ohloh : http://www.ohloh.net/accounts/4138 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to change parameter prefix
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)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Bug? Timeout at CheckMaxPoolSize 2.x
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. > > - John > ""Carlos Guzmán Álvarez"" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Hello: > >> ServerType=3D1;DataBase=3DC:\data\AyaNova = > > > >> 3.2\utils\AyaImport\AYANOVA.FDB;Dialect=3D3; > > > > Ok, so you are using the default connection pooling settings : > > > > connection lifetime =3D 0 // *Means connections in the pool never > dies > > != > > !!* > > min pool size=3D 0 // Min number of connection in the pool > > max pool size=3D 100 // Max number of connections in the pool > > connection timeout =3D 15 // Connection timeout > > > > > > > > So can you give a try by setting a value for the connection > > lifetime in the connection string ?? Set it for example to 10 ( > > what will mean connections will be closed when they 10 or more > > seconds in the pool ), and retry to see if it helps > > > > -- = > > > > Carlos Guzm=E1n =C1lvarez > > Vigo-Spain > > > > http://carlosga.blogspot.com/ > > > > No hay un solo rey que no descienda de un esclavo, > > ni un esclavo que no haya tenido reyes en su familia. > > > > > > > > > > ___ > > Firebird-net-provider mailing list > > Firebird-net-provider@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > > > > > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to change parameter prefix
Hello: > Ah, sorry. I was thinking that '@' is some recomendation for implementors. = > :) Don't worry :) that was decided in the early stages of the provider development ( the place holder is supported as well ) 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 ) > But no matter, from my POV changing it makes no sense. :) - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to change parameter prefix
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 ( depends on the RDBMS ), in the Firebird .NET Provider the
> @ was used for compatibility resons with Sql Server :) as it's not
> really supported by Firebird.
Ah, sorry. I was thinking that '@' is some recomendation for implementors. :)
But no matter, from my POV changing it makes no sense.
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to change parameter prefix
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 used for compatibility resons with Sql Server :) as it's not really supported by Firebird. -- Best regards Carlos Guzmán Álvarez - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to change parameter prefix
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:
> http://msdn2.microsoft.com/en-us/library/system.data.oracleclient.oraclecommand.parameters.aspx
It's magic, 'cause also unnamned params (?) are not supported. Looks
like some Cut'n'Paste implementation from another provider.
AFAIK Oracle has own provider on his site (I don't know differences
between framework's and "internal, but ...) - maybe it handles params
right.
> I couldn't find any nice workaround. May be someone had done some kind
> of wrapper that handle this? May be there is in Firebird provider some
> event handler that is triggered just before execution of statement? This
> way I could substitute the ':' with '@'?
Why do you need this? I don't think, that's a good idea to add to our
provider some magic code, to fix someones (oracle's) incompatibility.
Maybe you need something, that can be easily solved in another way.
BTW If you want to your application be able to work with oracle and FB
using same code and there's a problem with oracle-provider, why not to
use some constants and prefix params with it depending on selected
provider. It's not clear, it's not nice, but it solves problem.
> Regards.,
> ...michal
>
> Jiri Cincura pisze:
> > On 8/27/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >> 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
> >> prefix to ':'?
> >
> > 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.
> >
> > It's not long time ago, the fb .net provider supports also params
> > without '@' to better handle ASP.NET stuff. Carlos did it, look at
> > changelog. So maybe this is supported by oracle too.
> >
> > If you still want to chnage this character, you should look at
> > FbCommand, FbCommandBuilder and FbParameter classes. But I don't
> > think, it's a good idea, cause '@' is used on various places so
> > changing it can break something.
> >
>
> -
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to change parameter prefix
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 someone had done some kind of wrapper that handle this? May be there is in Firebird provider some event handler that is triggered just before execution of statement? This way I could substitute the ':' with '@'? Regards., ...michal Jiri Cincura pisze: > On 8/27/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >> 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 >> prefix to ':'? > > 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. > > It's not long time ago, the fb .net provider supports also params > without '@' to better handle ASP.NET stuff. Carlos did it, look at > changelog. So maybe this is supported by oracle too. > > If you still want to chnage this character, you should look at > FbCommand, FbCommandBuilder and FbParameter classes. But I don't > think, it's a good idea, cause '@' is used on various places so > changing it can break something. > - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to change parameter prefix
On 8/27/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> 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
> prefix to ':'?
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.
It's not long time ago, the fb .net provider supports also params
without '@' to better handle ASP.NET stuff. Carlos did it, look at
changelog. So maybe this is supported by oracle too.
If you still want to chnage this character, you should look at
FbCommand, FbCommandBuilder and FbParameter classes. But I don't
think, it's a good idea, cause '@' is used on various places so
changing it can break something.
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] how to change parameter prefix
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 prefix to ':'? Best regards, ...michal - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
