Need Help on Sql Compact(Dot Net)

See more:

VB

SQL

.NETCF

Hi All,
While performing the engine.Compact("Data Source = " & destinationDBName & ";Password =" & encryptedPassword) line in the code below, I am getting this exception: “Attempted to read or write protected memory. This is an often indication that other memory is corrupted”.

This fuction is actually creating a new database using a old one and encrypting it with a password. And one interesting thing is that it's giving no error in my system, but giving exception in another system.

So, please help me out on this.

Public Sub GlobalFunctions_Encrypt_DB(ByVal sourceDBName As String, ByVal destinationDBName As String, ByVal encryptedPassword As String) Implements ICommonDAO.GlobalFunctions_Encrypt_DB
        Dim engine As SqlCeEngine
 
        engine = New SqlCeEngine("Data Source = " & sourceDBName)
 
        ' Compact the database and add password protection
        engine.Compact("Data Source = " & destinationDBName & ";Password =" & encryptedPassword) '***This line errors        
        engine.Dispose()
End Sub

Regards,
Kapil Khurana



[Edit - Added code block, fixed spelling and grammar]