#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2004
    Posts
    5
    Rep Power
    0

    Connecting to FireBird without network thru .NET Provider


    Hi,
    I am using FireBird server 1.5 with FireBird .NET provider 1.5 to access to it.
    Iīm using this string connection to connect with the server:

    string connectionString =
    "User=SYSDBA; " +
    "Password=masterkey; " +
    "Database=D:\\SYSTEM\\SYSTEM.GDB;" +
    "DataSource=localhost;" +
    "Port=3050; " +
    "Dialect=3; " +
    "Charset=NONE; " +
    "Role=; " +
    "Connection lifetime=15; " +
    "Pooling=true; " +
    "Packet Size=8192";

    I need to use Firebird .NET Provider without network services. I have used before ODBC drivers but the performance of them are not the same than the .NET one.
    Iīm having troubles with the DataSource parameter when there is no net.
    Is there any way to use this provider without network services?
    Thanks
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    249
    Rep Power
    14
    Hi,

    Doesn't it work with "localhost"?

    With regards,

    Martijn Tonies
    Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server.
    Upscene Productions
    http://www.upscene.com
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2004
    Posts
    5
    Rep Power
    0
    No... It doesnīt work. Localhost is resolved by TCP/IP as 127.0.0.1. We donīt have TCP/IP installed in the machine... thus FbConnection canīt resolve Datasource location and throws an exception.
    Weīre trying now to connect the application to an embedded firebird server but we canīt connect with the Firebird .NET provider 1.5.4. version. We are using this connection string now:

    string connectionString =
    "User=SYSDBA; " +
    "Password=masterkey; " +
    "Database=D:\\SISTEM\\SISTEM.GDB;" +
    "Dialect=3; " +
    "ServerType= 1;";

    This connection string works perfectly with the 1.6. .NET provider version but when we use it with 1.5.4. version the FbConnection object throws this message:
    "Unable to complete network request to host \"D\".\n"
    Is there any way to connect with an embedded firebird version with the 1.5.4. Firebird .NET Provider connection?
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2004
    Location
    Cape Town, South Africa
    Posts
    51
    Rep Power
    11
    I thought the 1.5.4 .Net Provider can't be used embeded only 1.6?
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    249
    Rep Power
    14
    You might want to check if connecting to Embedded is new for 1.6 ... that might give you a clue.

    Anyway, apparently, it doesn't work with v < 1.6 - so you're out of luck with that.

    --

    With regards,

    Martijn Tonies
    Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server.
    Upscene Productions
    http://www.upscene.com
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com
  10. #6
  11. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    13
    Rep Power
    0
    Originally Posted by paul ankho
    Is there any way to connect with an embedded firebird version with the 1.5.4. Firebird .NET Provider connection?
    No embedded server support is new in v1.6

IMN logo majestic logo threadwatch logo seochat tools logo