Delphi accessing remote Derby DB

[dcroghan 0]

Hello,

Has anyone had success with a data connection to a remote Derby DB service?  I would certainly consider a 3rd party library/component.  I'm using D11.2 but could ever use a different version of Delphi if needed.  The remote Derby engine is on a Windows 11 computer.

 

Thank you for any help or insight.

[Brian Evans 105]

Apache Derby only provides JDBC clients / Java access. You could make use of an ODBC to JDBC bridge product like easysoft's ODBC-JDBC Gateway (https://www.easysoft.com/products/data_access/odbc_jdbc_gateway). Then in Delphi use ADO or FireDac to access the ODBC datasource. 

Edited February 27, 2023 by Brian Evans

[Ruslan 5]

Also make sure that windows firewall doesn't block remote connection to the db.

[dcroghan 0]

Thank you both for your help!