Subject | cannot disconnect database with open transactions |
---|---|
Author | theghost_k8 |
Post date | 2007-02-10T21:12:32Z |
Try
If fbcon.State = ConnectionState.Open Then
fbcon.Close()
fbcon.ClearPool(fbcon) << this returns error "cannot
disconnect database with open transactions (<number> open)"
End If
Catch ex As Exception
If Show_Error Then
MsgBox(ex.ToString)
End If
End Try
IS THERE ANY WAY I CAN CLOSE THIS TRANSACTIONS ?
If fbcon.State = ConnectionState.Open Then
fbcon.Close()
fbcon.ClearPool(fbcon) << this returns error "cannot
disconnect database with open transactions (<number> open)"
End If
Catch ex As Exception
If Show_Error Then
MsgBox(ex.ToString)
End If
End Try
IS THERE ANY WAY I CAN CLOSE THIS TRANSACTIONS ?