I am using Visual studio 2017 with .NET 4.0 and Firebird ADO provider version 4.6. I'm having trouble connecting to a database file on a different server then de Web service and the Firebird service.
So for example:
Firebird host: localhost
Firebird port: 3050
Database file path: \\\\server1\C$\Databases\test.fdb
When I try to setup the connection string I create it like below:
connectionstring = "User ID=sysdba;Password=masterkey;Database=localhost/3050:\\server1\C$\Databases\test.fdb;DataSource=localhost;Port=3050;Charset=NONE;";
When I try to connect I get the message "Unavailable database". When I try the same with a Delphi project it does work, so I am sure the host, port and path all work. Is this a bug in de .NET Firebird provider or how can I fix my connection string?
How I build connection string in Delphi:
connectionstring := 'localhost/3050:\\server1\C$\Databases\test.fdb';
By the way I've tried almost every other possibility for setting the database string part.