0

I know that this question has been already asked and that one of the solutions is to change WireCrypt setting in config file. However, my application has to connect to third party software that is using Firebird 3.0 db thus I do not have the control over db configuration. The question is: Is there any workaround to connect to firebird db (with default wirecrypt setting) from .Net application using Firebird Ado.net provider?

EDIT: Edit with regard to Mark Rotteveel answer. I have tried this approach but I was not able to force the connection to be made via TCP instead I got the error:

Unable to complete network request to host \"xnet://Global\FIREBIRD\".

Connection string generated by the builder: 

"server type=Embedded;initial catalog=C:\\foldername\\dbfile.ibb;data source=192.168.0.108;port number=3050;user id=****;password=****;client library=\"C:\\Program Files (x86)\\Firebird\\Firebird_3_0\\fbclient.dll\""
Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
RafalD
  • 3
  • 3
  • Possible duplicate of [Incompatible wire encryption levels requested on client and server with Firebird ado.net provider](https://stackoverflow.com/questions/37492890/incompatible-wire-encryption-levels-requested-on-client-and-server-with-firebird) – Mark Rotteveel Aug 22 '19 at 11:33

1 Answers1

0

To be able to use wire encryption, you need to update to Firebird ADO.net provider version 7. Version 7 added support for wire encryption, see ADO.NET provider 7.0.0.0 for Firebird is ready for more information.

Old answer

Ideally, the server needs to be configured to WireCrypt = Enabled, as clients are not allowed to downgrade the security requirements of the server.

If that really is not an option, then you should try to use the embedded server option of the Firebird ado.net provider. As the embedded server uses a native Firebird client library, it can also be used to connect to a Firebird server, and using the Firebird 3 fbclient.dll should therefor allow you to connect. However, I'm not 100% sure if this actually works with Firebird ADO.net provider, so I will test this and create a more detailed write-up later.

I haven't managed to get a connection to a server through embedded, so it looks like you have no other option than to have the server config changed (WireCrypt = Enabled).

Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
  • Thanks for quick reply I edited my question to provide further details regarding the workaround that you've suggested – RafalD Nov 30 '17 at 11:30
  • @RafalD I'll see if there is a trick to get it to work tonight. In the meantime, could you try with `initial catalog=localhost:C:\\foldername\\dbfile.ibb`? – Mark Rotteveel Nov 30 '17 at 11:51
  • I've installed firebird server on my computer and I've managed to connect to the database and retrieve data. However, this only works if my application is installed on the same machine as firebird server. If I change the initial catalogue to point to other computer on the network (i.e modify initial catalogue like this: 192.168.0.108:C:\\foldername\\dbfile.ibb) it ignores the ip address provided and connects to the db on the localhost. – RafalD Nov 30 '17 at 13:28
  • @RafalD That would seem to indicate the Firebird ADO.net provider actively only tries to offer embedded server, and not allow normal 'client' connections. – Mark Rotteveel Nov 30 '17 at 13:40