Hi, i have the following code:
try
{
cn.ConnectionString =
"User=SYSDBA;Password=masterkey;Database=/opt/firebird/dados/siad.gdb;DataSource=
192.168.15.254;Port=3050;Dialect=3;Charset=ISO8859_1;Role=;Connection
lifetime=0;Connection timeout=1;Pooling=True;Packet Size=8192;Server
Type=0";
cn.Open();
}
catch
{
try
{
cn.ConnectionString = cn.ConnectionString =
"User=SYSDBA;Password=masterkey;Database=/opt/firebird/dados/siad.gdb;DataSource=linux;Port=3050;Dialect=3;Charset=ISO8859_1;Role=;Connection
lifetime=0;Connection timeout=1;Pooling=True;Packet Size=8192;Server
Type=0";
cn.Open();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
Now it is with timeout=1 but it was 15 before and i was having connection
issues, after using my software for more then 10 minutes it started to
freeze, and after debugging it i figured out that firebird was returning
connection timeout.
And my debuuger keeps saying on the output window "a first chance of
Firebirsql.SystemException ocurred in FirebirdSql.dll
Is there something wrong with my connection string? How can i find out the
root of the problem? and why it just happens after 10 minutes or more after
i start my software?
thanx in advance for any reply.
--
Fabio Gomes
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
