ERROR in RDA.PULL

  

 [code]

    Private Sub create_DB()
        If File.Exists("STAFF.sdf") Then
            File.Delete("STAFF.sdf")
        End If
        Dim connStr As String = "Data Source = STAFF.sdf"
        Dim engine As New SqlCeEngine(connStr)
        engine.CreateDatabase()
        engine.Dispose()
    End Sub

 Private Sub pullData()
        Dim rdaOleDBConnectString As String = "Provider=sqloledb;Data Source=kangalert;Initial Catalog=ORDER;Integrated Security=SSPI"
        Dim rda As SqlCeRemoteDataAccess = Nothing
        Try

            rda = New SqlCeRemoteDataAccess 
            rda.InternetUrl = "https://kangalert/Server/sqlcesa30.dll"
            rda.InternetLogin = ""
            rda.InternetPassword = ""

            rda.Pull("STAFF", "SELECT * FROM STAFF",rdaOleDBConnectString, RdaTrackOption.TrackingOn)


            MsgBox("Pull Complete", MsgBoxStyle.Information, "PULL")

        Catch ex As Exception
            MsgBox("testing fail" + ex.ToString)

        Finally
            rda.Dispose()
        End Try


    End Sub

[/code]

MyComputer Name is = kangalert

The sqlserver 2005 database name is ORDER and table name is STAFF

 

Error Message is "A require property is not specified. [Property name = SubscriberConnectionString ] ; The parameter is either not specified or not valid.

 

Can any one please help me. Im so headache.



Answer this question

ERROR in RDA.PULL