It keep prompt me the error Native Error:
System.Data.SqlServerCe.SqlCeException was unhandled
HResult=-2147024809
Message="An error has occurred on the computer running IIS. Try restarting the IIS server."
NativeError=28022
Source="Microsoft SQL Server 2005 Mobile Edition"
StackTrace:
at System.Data.SqlServerCe.NativeMethods.CheckHRESULT()
at System.Data.SqlServerCe.SqlCeRemoteDataAccess.Pull()
at PDA2007.PULLPUSH.btn_pull_Click()
at System.Windows.Forms.Control.OnClick()
at System.Windows.Forms.Button.OnClick()
at System.Windows.Forms.ButtonBase.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at PDA2007.PULLPUSH.Main()
Below is my coding :
Private Sub btn_pull_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btn_pull.Click
Const gRemoteProvider = "Provider=SQLOLEDB.1;Persist Security
Info=False; " & _
"User ID=dmspda;Password=dmspda;Initial
Catalog=dmspda;Data Source=INSPIRON6000"
Const gInternetURL = "HTTP://192.168.1.3/Sync/SSCESA30.DLL"
Const gInternetLogin = "INSPIRON6000\IUSR_INSPIRON6000"
Const gInternetPwd = ""
Dim rda As SqlCeRemoteDataAccess
rda = New SqlCeRemoteDataAccess
rda.LocalConnectionString = "Data Source=\My Documents\pda.sdf"
rda.InternetUrl = gInternetURL
rda.InternetLogin = gInternetLogin
rda.InternetPassword = gInternetPwd
rda.Pull("pda_uom", "Select * from pda_uom", gRemoteProvider,
RdaTrackOption.TrackingOn)
End Sub
I have been refer to a lot of website and read articles, help forum, have try to disable Firewall, allow HTTP and HTTPS, uninstall anti-virus system. I have no idea, what is this problem and how to solve it ? If you face same problem before, hope can give some comment here, appreciate it!
Developed Machine:
* XP Pro S2
* SQL Server 2005 Express Edition
* Visual Studio 2005
Device :
* SQL Mobile 2005
* Window Mobile 5.0
Hullo xiaoytan
I have facing the same error as u faced, could u solved this pbm, then please let me know , how to do it ?
Thank u.
No comments:
Post a Comment