RDA SQL Server CE (Windows Mobile 5.0) > SQL Server 2000

Hello,

I have a few applications that i wrote in VS 2000 that use RDA to connect to SQL Server 2000 and transfer data from a SQL Server CE 2.0 database to SQL Server 2000.

Recently, I upgraded to VS 2005 AND a new handheld device with Windows Mobile 5.0.  After upgrading the programs that use only a database on the handheld worked fine, but the RDA section was giving an error (i have gone through many diffrent errors with diffrent configurations).

When i have Windows Mobile SQL Mobile 2005 installed I get an error that the System.Data.SQLServerCe is not found or not working properly.  When I have Windows SQL Mobile 2005 AND SQL Server CE 2.0 installed I get an error message that says Cannot open database file, invalid format.

When i programmed these in VS 2000 I used Rob Tiffany's "SQL Server CE Database Development with the .NET Compact Framework".  I am looking for a similar guide.

Thanks

Here is a list of the installed, relivant programs on the handheld at the moment (sorry for the cut off on some of them, I don't know how to view the full name on the Add/Remove programs list on the handheld)...

Microsoft SQL Client 2.0 [EN]
Microsoft SQL Client 2.0
Microsoft SQL Server 2005 Compa...
Microsoft SQL Server 2005 Compa...
Microsoft SQL Server 2005 Compa...
Microsoft .NET CF 1.0 ENU-String...
Microsoft SQL Client
Microsoft SQLCE 2.0 Dev
Microsoft SQLCE 2.0
Microsoft .NET Compact Framework
Microsoft SQL Mobile 2005 Replicat...
Microsoft SQL Mobile 2005 [EN]
Microsoft SQL Mobile 2005


And here is the error im getting on Visual Studio 2005...

A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll

Here is what the "MsgBox(sqlError.Message)" is returning...

"SQL Server CE encountered problems in opening the SQL Server CE database.  [,,,Database name,,]"

AND

"The file is not a valid database file.  An internal error has occurred. [,,,Database name,,]"

And here is the code that I think is relivant in my VB program (I can post more if needed)...

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:

Imports System.IO
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlServerCe
Imports System.Reflection
Imports System.Runtime.InteropServices
Imports System.Windows.Forms
 
Private Sub PushData(ByVal FileName As String)
       Dim rda As SqlCeRemoteDataAccess
       Dim username As String
       Dim password As String
       username = UsernameInput.Text
       password = PasswordInput.Text
       username = "xxxxx"
       password = "xxxxx"
       Try
           'Instantate the RDA object
           rda = New SqlCeRemoteDataAccess
 
           'Connection string to sql server
           Dim remoteConnectionString As String = "Provider=SQLOLEDB;Data Source=xxx.xxx.x.x;Initial Catalog=xxxxxx;User Id=sa;Password=xxxxxx"
           rda.InternetLogin = username
           rda.InternetPassword = password
           rda.InternetUrl = "http://xxx.xxx.x.x/NewHandheldRDA/sqlcesa30.dll"
           Dim TempString As String
           TempString = "Data Source=" & FileName & ";SSCE:Database Password="
           rda.LocalConnectionString = TempString
 
           rda.Push("RandomWeightsRDA", remoteConnectionString, RdaBatchOption.BatchingOn)
       Catch sqlex As SqlCeException
           Dim sqlError As SqlCeError
           For Each sqlError In sqlex.Errors
               MsgBox(sqlError.Message)
           Next
       Catch ex As Exception
           MsgBox(ex.Message)
       Finally
           rda = Nothing
       End Try
   End Sub