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

  • 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 

    Monday, July 25, 2011 9:32 AM

Answers

  • 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;"
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, July 25, 2011 10:27 AM

All replies

  • User-718146471 posted

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

    Monday, July 25, 2011 9:37 AM
  • 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.
    Monday, July 25, 2011 10:00 AM
  • 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;"
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, July 25, 2011 10:27 AM