hi,
i think you will do best to put there dispose calls to... There are same
leaks (or something like that) in firebird (may be in provider)
and i found that if you use reader you have to dispose it too...
p.
> Hello:
>
> myConnection.Close() make a Rollback of the transaction, try with this:
>
> myConnectionString =
>
"Database=C:\\interbase\\Usertasks\\xxx.GDB;User=xxx;Password=xxx;Dialect=3;
Server=xxx"
> myConnection = new FbConnection(myConnectionString)
> myConnection.Open()
>
> Dim UpdateCmd As String
>
> Updatecmd = "UPDATE users SET fname = 'Andrew' WHERE userid = " &
> txtuserid.Value
>
> myTxn = myConnection.BeginTransaction()
>
> MyCommand = New FbCommand(updateCmd, MyConnection, myTxn)
>
> Try
> MyCommand.ExecuteNonQuery()
> Message.Style("color") = "Green"
> Message.InnerHtml = "<b>Account has been updated.</b><br>"
>
> myTxn.Commit()
myTxn.Dispose()
myCommand.Dispose()
> Catch Exp As FbException
> Message.Style("color") = "red"
> Message.InnerHtml = "ERROR: Could not update Account: <br>" &
Exp.Message
> myConnection.Close()
> End Try
>
> myConnection.Close()
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
|
