Problem In PULL method...

[vendi_naren]

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")

[Strider]

what is the error????? There are many different errors that can occur during RDA!!!!

did you have a look at this post http://www.vbforums.com/showthread.php?t=364268

[vendi_naren]

hai strider,

My Error is Follows

An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll

Additional information: SqlCeException

[Strider]

add a try catch around the code

try

catch ex As sqlceexception
msgbox ex.message
end try

is sqlce installed on the handheld?

[vendi_naren]

i tried by putting try block....but is of no use....same eror coming...


here iam listing code below


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

Try

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 rdaOleDbConnectString As String = "Provider=sqloledb;DataSource=SOFT;InitialCatalog=MobileData;UserId=sa;Password ="


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")
Catch ex As Exception

MsgBox(ex.Message.ToString)
End Try

[petevick]

Hi,
single step through, and see where it hits an error

Pete