From: <de...@se...> - 2004-08-10 13:33:01
|
Hi I have problem with stable relase 1.6 Firebird .NET provider (sorry for very bad english) I have .NET 1.1 and Firebird 1.5 Connection string is User=3D{0};Password=3D{1};Database=3Dc:\\something\\data.fdb;DataSource= =3Dlocalhost;Port=3D3050;Dialect=3D3;Charset=3DWIN1250;Role=3D;Connecti= on Lifetime=3D15;Pooling=3Dtrue;Packet Size=3D8192" my code =09=09=09try =09=09=09{ =09=09=09=09FbConnection=09myConnection =3D new FbConnection(Connection= String); =09=09=09=09myConnection.Open(); =09=09=09=09TestString=3DExecQuery; =09=09=09=09FbTransaction=09myTransaction=09 =3D myConnection.BeginTra= nsaction(); =09=09=09=09FbCommand=09=09myCommand =3D new FbCommand(ExecQuery, myCon= nection, myTransaction); =09=09=09=09try =09=09=09=09{ =09=09=09=09=09myCommand.ExecuteNonQuery(); =09=09=09=09=09myCommand.Transaction.Commit(); =09=09=09=09=09myCommand.Dispose(); =09=09=09=09=09return true; =09=09=09=09} =09=09=09=09finally =09=09=09=09{ =09=09=09=09=09myConnection.Close(); =09=09=09=09} =09=09=09} =09=09=09catch (Exception myException) =09=09=09{ =09=09=09=09throw myException; =09=09=09} randomly myConnection.Close except this message Object reference not set to an instance of an object. This code is part of big ASP.NET application and here is many query exe= cutions in time. This exception thrown randomly. I use 1.5 version of .NET provider and with this version is all OK. It is my bug or it is bug of provider or it is bug of Firebird server? ____________________________________________________________ Obchodn=ED d=F9m.cz - =B9irok=FD sortiment dom=E1c=EDch spot=F8ebi=E8=F9= a elektroniky, v=FDrazn=E9 slevy. Nav=B9tivte http://ad.seznam.cz/clickthru?spotId=3D73742 |