<div dir="ltr">Thank you for your reply.<div><br></div><div>I had mistakenly thought that the "Firebird File" option was a client option, but now my understanding is that this is a normal Firebird .fdb file connected using the embedded server.<div>
<br></div><div>So I have been trying out the 4.2RC1 on both Windows 8 and Ubuntu 12.10. </div><div><br></div><div>What I see is that the 'fully' embedded option (i.e. the .fdb compressed/uncompressed to/from the .odb file) works to a degree, but I have problems with the "Firebird File" option on both Windows and Linux.</div>
<div><br></div><div>On Windows I get an "Unable to complete network request to host {myhostname}" message, which is strange for the embedded database.</div><div><br></div><div>On Linux everything appears to work, but any data entered is not properly stored. The data is apparently entered okay, it is even possible to create a query and query the newly entered data, but if you close and re-open the file then the data is gone. This looks like a transaction not be committed or rolled back, but I had always thought that as long as the "Save" button was greyed out that Base had successfully committed the transaction.<br>
<div><br></div><div>>> This shouldn't be hugely complicated to do, the main issue is in setting up and/or getting access to a </div><div>>> firebird server to test that it actually works, which is why is the main reason I haven't tried to do this yet </div>
<div>>> -- all contributions in this area would be greatly appreciated :).<br></div><div><br></div><div>I am more than happy to setup various Firebird servers on Windows 8, XP and Linux and do what ever testing you need. However one problem is that I have never been able to build LO from source so would you be able to put the changes into the master?</div>
<div><br></div></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Dec 30, 2013 at 9:16 PM, Andrzej Hunt <span dir="ltr"><<a href="mailto:andrzej@ahunt.org" target="_blank">andrzej@ahunt.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
There isn't any firebird server support yet -- however it shouldn't
be hugely<br>
complicated to add -- what's needing doing is allowing setting and<br>
passing the required parameters (url/username/password/etc.) to
firebird<br>
-- the passing of the parameters is actually already in place, we
just need<br>
to add an easy way for the user to pass them in / parse them.<br>
<br>
I.e. I would suggest:<br>
<br>
1. Adding a "Firebird Server" driver entry to allow entry of
username/password<br>
in addition to url:<br>
connectivity/registry/firebird/org/openoffice/Office/DataAccess/Drivers.xcu<br>
This would be pretty similar to any of the other remote server
driver entries in the other connectivity/registry/*/..../Drivers.xcu
files.<br>
(I suspect it's easiest to have separate driver entries, rather than
try to have one entry dealing with both local files and servers,
although we can probably share the same sdbc:firebird: prefix).<br>
<br>
2. Add some supporting code to:<br>
connectivity/source/drivers/firebird/Connection.cxx<br>
I.e. we need to parse the username/password/url from the new driver
configuration added above (the code to pass username/passwords/urls
to firebird itself is already in place, so we just need to set the
parameters appropriately based on user input).<br>
<br>
3. Possibly adapt<br>
dbaccess/source/ui/dlg/ConnectionHelper.cxx<br>
To only apply the ".fdb" filter when we're configuring "Firebird
File" and not for "Firebird Server".<br>
(I suspect this wouldn't be necessary if we use a separate prefix
though).<br>
<br>
This shouldn't be hugely complicated to do, the main issue is in
setting up and/or getting access to a firebird server to test that
it actually works, which is why is the main reason I haven't tried
to do this yet -- all contributions in this area would be greatly
appreciated :).<br>
<br>
Cheers,<br>
<br>
Andrzej<div><div class="h5"><br>
<br>
<div>On 30/12/13 15:34, iwbnwif yiw wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div class="h5">
<div dir="ltr">
<div>I would like to join in the testing of the Firebird SDBC as
I have been using both Firebird and OO/LO for many years and
very happy to see them being properly integrated.<br>
<br>
</div>
<div>Although I have been getting on well with the embedded
files (i.e. fdb embedded in odb), I can't work out the URL
format for connecting with a server using the "Firebird File"
option in connect to an existing database.<br>
<br>
</div>
Thanks...<br>
<div><br>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
LibreOffice mailing list
<a href="mailto:LibreOffice@lists.freedesktop.org" target="_blank">LibreOffice@lists.freedesktop.org</a>
<a href="http://lists.freedesktop.org/mailman/listinfo/libreoffice" target="_blank">http://lists.freedesktop.org/mailman/listinfo/libreoffice</a>
</pre>
</blockquote>
<br>
</div>
</blockquote></div><br></div>