Re: [Firebird-net-provider] Linux
At 04:00 AM 15/08/2007, you wrote: >Hello all! > >I have a program run under Windows, and it works fine. >I use VS2005 and Firebird .NET Data Provider. >The Server is Windows Server 2003 and the clients are WXP. >I am using .net Compact Framework 2 sp 2 with FirebirdClient-1.5.2 to access >FireBird 1.5 SS. > >I would like to change the Server to Linux. >The same code, will it work ? In principle, it can. On the whole this is not a .NET provider issue at all, provided your application code and databases have been created with interoperability in sight. However, if you hard-coded file paths into your application, or used Full settings for configuring the server's access to things like UDFs, or if you defined external tables in your database, you will have to do some changes. Except for external tables, all of the other changes will keep your application workable on Windows, too. You would just use a different firebird.conf file for each host environment. In summary: a database alias should be used for the database file path and your apps should always use the alias. All configurations that access external objects (UDFs, blob filters, etc.) should be RESTRICT or NONE, with the hard paths configured in firebird.conf. The server's hostname should be made configurable by the client (by a Registry setting or .ini file, or by user input). If you have any UDFs or blob filters declared in the database, fix up the issues before you back up the database for transportation. (And do make sure that a version of your UDF is actually available for Linux!) As for external tables, you should drop them from the database before you back up ready for transporting. You can recreate them with a script once you have ported the database and created a location on the Linux server for them. Helen - 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] Linux
On 8/14/07, Eduardo <[EMAIL PROTECTED]> wrote: > I would like to change the Server to Linux. > The same code, will it work ? Yes. -- 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] Linux
Hello all! I have a program run under Windows, and it works fine. I use VS2005 and Firebird .NET Data Provider. The Server is Windows Server 2003 and the clients are WXP. I am using .net Compact Framework 2 sp 2 with FirebirdClient-1.5.2 to access FireBird 1.5 SS. I would like to change the Server to Linux. The same code, will it work ? Thanks - 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] Possible bug in Solaris
On 8/14/07, pablosantosluac <[EMAIL PROTECTED]> wrote: > When you read a char field of lenght 1, Windows and Linux return a char of 1 > but in Solaris you get a string with the value and 2 blanks. It's probably problem in Mono when both Linux and Windows versions working. -- 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] Possible bug in Solaris
Hi, I've detected the following problem in Solaris with version 1.7.1.0. I'm using mono 1.2.4. When you read a char field of lenght 1, Windows and Linux return a char of 1 but in Solaris you get a string with the value and 2 blanks. Pablo - 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] System.Transaction Integration
Hi, I'm having difficulties understanding the System.Transcaction Integration for FbConnection. (a) Why is it not possible to enlist in a transaction dynamically? One has to use Enlist=true in the connection string during Open() to get a _enlisted_ connection. What if I want to enlist dynamically later? The EnlistTransaction() should do that, but it does not do what the name says, as it requires the Enlist option to be set. And that can only be set from the connection string for Open() If one looks at the Oracle provider, there we have a Enlist=false/true/dynamic setting which actually better describes the configuration. Even better would be to allow dynamic enlistment without looking at the connection string options; that should be possible. (b) If Enlist=true is given during Open(), but no System.Transaction is returned from System.Transaction.Current, the data provider crashes. (c) The isolation level is hard wired to be ReadCommitted, despite what the System.Transactions.Transaction instance says. This makes it practically impossible to use other isolation levels with Firebird although that would easily be possible. (d) It seems there is no real prepare phase and not a real integration into MSDTC supporting reenlistment in case of a crashed MSDTC. Is this documented somewhere or am I missing something? (e) It seems to me that prepared statements cannot be used in an enlisted transaction as one is not able to obtain the database transaction to set that to FbCommand.Transaction. Is anyone else having success with the System.Transaction Integration? Thanks - Thomas - 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] Examples of database restore and table
Hello: > I'm looking for some links that explain how to restore databases, and > create tables on new databases, using the Firebird .NET data provider. > Can anyone please point me in the right direction? I'm using version > 2.0.1 BTW. While they are for v1.7 you can find 2 examples here: http://www.firebirdsql.org/index.php?op=devel&sub=netprovider&id=examples#4 -- Best regards Carlos Guzmán Álvarez Vigo-Spain - 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