Connect to Firebird 4

[rubenfasilva]

Hello.

I've been using talend open studio with Firebird 2x for many years with no issues.

Now, I am trying to connect Talend Open Studio with Firebird 4 database, and no luck.

I have this error:

Exception in component tDBConnection_1 (fb4)

org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544421. connection rejected by remote interface

I know that might be an jdbc driver issue, and if it is, is it possible to upgrade jdbc driver on talend open studio?

Or is it some other issue?

Note: I am able to connect via windows odbc drivers and I aldo tested with dbeaver and is possible to connect...

Any ideas?

Thank you.

[Anonymous · Accepted solution]

Hello,

You could try to override the jar file by following this documentation.

https://help.talend.com/r/en-US/8.0/studio-user-guide-open-studio-for-data-integration/overriding-ex...

Feel free to let us know if it helps.

Best regards

Sabrina

[rubenfasilva]

Hello.

Thank you for your answer, but I found the issue.

What I did was:

On firebird server side -> firebird.conf file I added this:

AuthServer = Legacy_Auth

AuthClient = Legacy_Auth

UserManager = Legacy_UserManager

WireCrypt = Disabled

Then I restarted firebird service and it worked

I hope this helps others!

Cheers!

[Anonymous]

Hello,

Thanks for sharing your solution with us on Community.

What's the issue you got? Some security or authentication error?

Best regards

Sabrina