Reconnect to another FireBird DB without exiting from an Application
--------------------------------------------------------------------

                 Key: DNET-637
                 URL: http://tracker.firebirdsql.org/browse/DNET-637
             Project: .NET Data provider
          Issue Type: Task
          Components: ADO.NET Provider
    Affects Versions: 4.7.0.0
         Environment: Visual Studio 2010, .NET 4.0 Visual Basic
            Reporter: Ivan Ivanovich
            Assignee: Jiri Cincura


I have connected to FB Database using FBConnection class and Retreive  Data 
using FBDataAdapter. ALL Go OK.

Now I need to close current connection and connect to another  FB Database 
without exiting a Program.

I do it by issuing the code below:

Public FB_Con As FBConnection

FB_Con = New FBConnection

'-------------Processing Data

FB_Con.Close()
FbConnection.ClearPool(FB_Con)
FB_Con.Dispose()

Then I issue FB_Con.Open with new connection string (to another FB Database)

I want to be careful with the other users, which are connected to FB server.

Is this variant is good and careful?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to