Connection String For PDA

Hello,

I am using VS 2005 and developing PDA device application to run on SQL CE. The PDA has Windows CE 5.0 OS.

Now I am using the following code for connection to database: I got this code from some website on Internet but do not remember which one:

Try
Dim FullAppName As String = [Assembly].GetCallingAssembly().GetName.CodeBase
Dim FullAppPath As String = Path.GetDirectoryName(FullAppName)
MessageBox.Show(FullAppPath)

Dim FullFileName As String = Path.Combine(FullAppPath, "Test123.sdf")
Dim cn As New SqlCeConnection(String.Format("Data Source={0}", FullFileName))
MessageBox.Show(FullFileName)
cn.Open()
MessageBox.Show("Connection Success")

Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try

Here the problem is that
1. FullAppPath returns Windows. But the database is in application folder i.e. Program FilesDeviceSampleApp. Then why does it return Windows.

2. So I copied the test123.sdf file in Windows folder. But cn.Open goes to catch block. This means there is some error but surprisingly ex.ToString displays blank messagebox. What could be the issue?


3. I also changed the connection string as:
Dim cn As New SqlCeConnection("Data Source = Program FilesDeviceSampleAppTest123.sdf") and the Test123.sdf correctly gets deployed to this folder Program FilesDeviceSampleApp which also has the EXE. Still it gives error that it cannot find the database Test123.sdf in the path Program FilesDeviceSampleApp but I checked and it is there. What could be the issue?

Regards,
MI