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 [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
