VB2005 - Kill Connection to Database

[bbetoo]

Hi.
I'm using VB 2005 Express Edition and made a database using SQL SERVER 2005 Express Edition. I'm trying to copy that database used inside my program to an alternate location but in the DEBUG mode I keep getting the message that the file is in use even though I have made .close() procedure.
The original database is located in c:\XXX\RADS_DB.mdf and I want to copy it c:\XXX_UP\RADS_DB.mdf
I use the my.computher.filesystem.copyfile method.
Thanks in advance,

bbetoo

[shweta123]

Hi,

Can you please specify your coding? Have you closed all the connections from the code?

Also it is possible that Database is opened itself.

[bbetoo]

Thaks for the reply.
I actually closed all connections using:
connBD.close()
The code is the following:

Public strcon as string = "Data Source=.\SQLEXPRESS;AttachDbFilename=c:\XXX\RADS_D B.mdf;Integrated Security=true; Connect Timeout=30;User Instance=True"
Private connBD as SqlConnection
Private sub routine()
dim connBD as new SqlConnection(strcon)
connBD.open()
'routine using the database
connBD.close()
my.computer.filesystem.copyfile(c:\XXX\RADS_DB.mdf ,c:\XXX_UP\RADS_DB.mdf)
end sub

it keeps giving me the error that program is using the file RADS_DB.mdf in the debug mode.

thanks in advance,

bbetoo

Hi,

Can you please specify your coding? Have you closed all the connections from the code?

Also it is possible that Database is opened itself.