I'm using the RDA - Pull method to download data from my SQL Server
2000 database to my WINCE5.0. I have this working fine in my
environment,
but when I try to run it on a clients network I am getting an error.
Error Code: 80070005
Message :
Minor Err.: 0
Source : Microsoft SQL Server 2005 Mobile Edition"
When I browse out to the SSCESA30.DLL file from IE Explorer, I do get
"Microsoft SQL Server Compact Edition Server Agent" returned,
but only if I enter the domain (along with UID & PWD)
when prompted from the explorer session. Do I need the domain
somewhere in the connection string of my program? All I have in it now
are the URL Login & URL Pwd. If I do, can anyone give me an example of
how I would add it to my vs2005 code. Thanks.
This is my code:
Private Sub pull()
Dim strLocalConnect As String
Dim strRemoteConnect As String
strRemoteConnect = "Provider=SQLOLEDB;Data Source=LF-
WINXP;User ID=sa;Password=jianwei;Initial Catalog=SPMS2005"
strLocalConnect = "Data Source=" + DatabaseName
Try
Dim rda As SqlCeRemoteDataAccess = New
SqlCeRemoteDataAccess()
Dim strSelectTablerToD As String
strSelectTablerToD = "SELECT * FROM dbo.issue"
rda.InternetLogin = ""
rda.InternetPassword = ""
rda.InternetUrl = strInternetURL
rda.LocalConnectionString = strLocalConnect
rda.Pull("xx", strSelectTablerToD, strRemoteConnect, _
System.Data.SqlServerCe.RdaTrackOption.TrackingOff)
Catch ex As SqlCeException
ShowErrors(ex)
End Try
End Sub