Hi, I did an ssh tunnel to a remote server that has a Firebird 2.5 database, this way, my computer can connect to that database by simply pointing to 'localhost', this works when I connect through FlameRobin, but I can't make it work using this simple program:

program dbtest;
{$mode objfpc}
uses
  Classes, SysUtils, IBConnection, sqldb;
var
  IBConnection1: TIBConnection;
  SQLTransaction1: TSQLTransaction;
  lSql: TSQLQuery;
begin
  IBConnection1 := TIBConnection.Create(nil);
  IBConnection1.DatabaseName := 'test';
  IBConnection1.UserName := 'SYSDBA';
  IBConnection1.Password := 'masterkey';
  IBConnection1.HostName := 'localhost';
  IBConnection1.CharSet := 'UTF8';
  IBConnection1.LoginPrompt := False;
  IBConnection1.Connected := True;
  IBConnection1.Free;
end.

When I run it, I get this exception:

An unhandled exception occurred at $0000000000488EFB : EIBDatabaseError : : DoInternalConnect :
-database /usr/path_to_database/TEST.IB shutdown
$0000000000488EFB
$000000000048A1E1
$0000000000489C98

What can be causing this error?

P.S.: I'm connecting from an Ubuntu 10.10 64bits box with libfbclient2 ver 2.5.0.26074-0.ds4-4, and the server is a FreeBSD 8.2 64bits with Firebird 2.5.

Thanks in advance,
Leonardo M. Ramé
http://leonardorame.blogspot.com

this error message isc_shutdown is throw during isc_attach_database and so it seems, that your database is in shutdown mode (which prevents you attach ... but I do not understand why you can success fuly attach using ssh?)
See http://www.firebirdnews.org/?p=234
http://www.destructor.de/firebird/gfix.htm
Laco.

Thanks, I found the log "firebird.log" file was growing too much and consumed all my /var partition free space.

but I do not understand why you can success fuly attach using ssh?) See http://www.firebirdnews.org/?p=234       http://www.destructor.de/firebird/gfix.htm Laco.

I don't attach trough SSH, with SSH I made a tunnel connection to my server, than attached from my machine to "localhost" on port 3050.

Leonardo M. Ramé
http://leonardorame.blogspot.com