Hello,

I have an SQL 2005 server with Connectivitiy tools and Windows Mobile 2003
and 5.0 clients.

The solution has recently been migrated from SQL 2000 to 2005.

I have an error message when making transfer with the main SQL 2005 database.

Error message:
----------------------------------------------------------------------------------------------
"an sql mobile dll could not be loaded, reinstall SQL Mobile dll name
sqlceca30.dll"
----------------------------------------------------------------------------------------------

The following is my code: It does not get to MsgBox("2")
-----------------------------------------------------------------
       Dim RdaStr As String = "Provider=SQLOLEDB; Data Source=" + Server +
";Initial Catalog=" + DataBase + ";Integrated Security=SSPI"
       Dim rda As SqlCeRemoteDataAccess = Nothing
       Try
          MsgBox("1")            
          rda = New SqlCeRemoteDataAccess
          MsgBox("2")
       Catch ex As Exception
           MsgBox(ex.ToString)
           Application.Exit()
       End Try

       Try
           rda.InternetLogin = [String].Empty
           rda.InternetPassword = [String].Empty
           'rda.InternetUrl = "http://" + IP_no + "/ssce/sscesa20.dll"
           rda.InternetUrl = "http://" + IP_no + "/ssce3/sqlcesa30.dll"
           'rda.LocalConnectionString =
"Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;" & ConnectString
           rda.LocalConnectionString = ConnectString
       Catch ex As Exception
           MsgBox("Bağlantı hatası..")
           Application.Exit()
       End Try
-----------------------------------------------------------------------

Windows Mobile 5.0 clients work fine. The error message appears only on
Mobile 2003 clients.

sqlceca30.dll is there

The following are already installed
- sqlce30.ppc.wce4.armv4.CAB
- sqlce30.dev.ENU.ppc.wce4.armv4.CAB
- sqlce30.repl.ppc.wce4.armv4.CAB
- Compact Framework 2.0

when installed for the first time the database gets replicated with SQL 2005
and all changes are committed. After I exit the program and re-enter, this
error message comes up.

As I said before this is true for only Windows Mobile 2003 clients. Mobile
5.0 cliensts work fine.

I would be very pleased if you could help me. I googled and looked
everywhere but couln't find anything.

Regards,

Abdullah SEN