There isn't any firebird server support yet -- however it shouldn't be hugely
complicated to add -- what's needing doing is allowing setting and
passing the required parameters (url/username/password/etc.) to firebird
-- the passing of the parameters is actually already in place, we just need
to add an easy way for the user to pass them in / parse them.

I.e. I would suggest:

1. Adding a "Firebird Server" driver entry to allow entry of username/password
    in addition to url:
 connectivity/registry/firebird/org/openoffice/Office/DataAccess/Drivers.xcu
This would be pretty similar to any of the other remote server driver entries in the other connectivity/registry/*/..../Drivers.xcu files. (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).

2. Add some supporting code to:
 connectivity/source/drivers/firebird/Connection.cxx
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).

3. Possibly adapt
 dbaccess/source/ui/dlg/ConnectionHelper.cxx
To only apply the ".fdb" filter when we're configuring "Firebird File" and not for "Firebird Server".
(I suspect this wouldn't be necessary if we use a separate prefix though).

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 :).

Cheers,

    Andrzej

On 30/12/13 15:34, iwbnwif yiw wrote:
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.

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.

Thanks...



_______________________________________________
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

_______________________________________________
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Reply via email to