Conecting ASP.net c# with an interbase database using firebird

Question

User-1941345780 posted

hey all,

iv just downloaded the latest version of Firebird ADO.NET Data Provider and im trying to create a connection to my interbase database, which is on a server, can any one please advice me on where i can take a look at some example code. I have tried looking on the firebird website for some example code but had no luck 

Answer 1

User-718146471 posted

For the code, please check out www.connectionstrings.com as they have them all.

Answer 2

User-1941345780 posted

iv tried using the connection string mentioned in the website you provided the issue is im trying to connect to a database which is on different server, im using the following connection stirng

        String ConnectionString = "User=SYSDBA;Password=masterkey;Database=\\server50:D:\\database\\Data\\play.ib;DataSource=playdatabase;

 Port=3050;Dialect=3; Charset=NONE;Role=;Connection lifetime=15;Pooling=true; MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;

ServerType=0;";

but i keep getting the following error

Exception Details: FirebirdSql.Data.Common.IscException: Unable to complete network request to host "\server50".

any ideas on how i may be able to resolve this.

Answer 3

User-718146471 posted

Try it this way:

String ConnectionString = "User=SYSDBA; Password=masterkey; Database=D:\\database\\Data\\play.ib; DataSource=SERVER50\\playdatabase; Port=3050; Dialect=3; Charset=NONE; Role=; Connection lifetime=15; Pooling=true; MinPoolSize=0; MaxPoolSize=50; Packet Size=8192; ServerType=0;"