Close all connections to database

[bbetoo]

Hi all.
I'm using VB2005 with SQL Server Express Ed. When I try to copy the database file to another location I get an error message warning me that those files are still in use. Is it to possible to perform this operation??? How???

[hariharanmca]

Hi all.
I'm using VB2005 with SQL Server Express Ed. When I try to copy the database file to another location I get an error message warning me that those files are still in use. Is it to possible to perform this operation??? How???

No,Only thing is you have to stop your VB2005 App. Becouse VB2005 Appi Opening the Database

[bbetoo]

You mean that only by restarting the application can I break the link to the database????

[pweegar]

You probably need to do a couple of things.

1) In your code, you need to close your db connection. Then you need to set that connection to nothing to get rid of it. Anytime you are done with a connection it should be closed.

2) Are you moving just the database or will you include sql server 2005 express in your app? IF you are moving just the database, you will need to detach it from SQL Server 2005. Do you have Studio Management Express installed? (It's free from MS). You can detach from this. However, anywhere you want your application, you will need SQL Server and you will need to reattach it. Or you can set up your app for network use.

[bbetoo]

This is what i'm trying to due:

Private Sub btnExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExit.Click
If (MsgBox("Are you sure you want to exit the application?", MsgBoxStyle.YesNo) = MsgBoxResult.Yes) Then
SqlConnection.ClearAllPools()
Dim strcon As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=" & strcon_file & "\close.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
Dim connBD As New SqlConnection(strcon)
Dim connBD_Limits As New SqlConnection(strcon)
My.Computer.FileSystem.CopyFile(strcon_file & "\RADS_DB.mdf", strcon_network & "\RADS_DB.mdf", True)
My.Computer.FileSystem.CopyFile(strcon_file & "\RADS_DB_log.ldf", strcon_network & "\RADS_DB_log.ldf", True)
'My.Computer.FileSystem.CopyFile(strcon_file & "\reports\Anexo_C.xls", strcon_network & "\reports\Anexo_C.xls", True)
'My.Computer.FileSystem.CopyFile(strcon_file & "\reports\Anexo_D.xls", strcon_network & "\reports\Anexo_D.xls", True)
'My.Computer.FileSystem.CopyFile(strcon_file & "\reports\Anexo_E.xls", strcon_network & "\reports\Anexo_E.xls", True)
'My.Computer.FileSystem.CopyFile(strcon_file & "\help\RADS_DB - Manual de Utilização.pdf", strcon_network & "\help\RADS_DB - Manual de Utilização.pdf", True)
'My.Computer.FileSystem.CopyFile(strcon_file & "\help\PAC A34 025.pdf", strcon_network & "\help\PAC A34 025.pdf", True)
'If My.Computer.FileSystem.DirectoryExists(strcon_file & "\files") = True Then
'My.Computer.FileSystem.CopyDirectory(strcon_file & "\files", strcon_network & "\files", True)
'End If
Me.Close()
End If
End Sub

[hariharanmca]

You mean that only by restarting the application can I break the link to the database????

No, I mean to stop compailing your code.before that you've to be sure that all the connections opened are closed properly