hi frnds,


iam trying to get data from sql server to sql server ce.....but it is generating error......


plz refer my code and suggest some changes.......my code follows


If File.Exists("\Temp\naren.sdf") Then
File.Delete("\Temp\naren.sdf")
End If


Dim objsqlengine As New SqlCeEngine("Data Source=\Temp\naren.sdf")
objsqlengine.CreateDatabase()


Dim rdaOleDbConnectString As String = "Initial Catalog=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=MobileData;Packet Size=4096;Workstation ID=SOFT;"

Dim rda As New SqlCeRemoteDataAccess


rda.InternetUrl = "http://localhost/SQLCE/Sscesa20.dll"
rda.LocalConnectionString = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\Temp\naren.sdf"


rda.Pull("student", "Select * from student", rdaOleDbConnectString, RdaBatchOption.BatchingOn)
MsgBox("Pull operation completed", MsgBoxStyle.Information, "Pull")