Remote Data Access

[jasmine]

I'm a newbie to the .NET CF.
I'm trying to connect to the SQL Server CE database using
RDA object. However, i'm stuck with the very first step -
Pull method. Every time I'm trying to Pull the table, it
gave me this error message:

Error Code: 80072EFD
Message: A request to send data to the computer running
IIS has failed. For more information, see HRESULT. [,,,,]
Minor Err: 28037
Source: Microsoft SQL Server 2000 Windows CE Edition

Below is the code i used from the sample i found online.
Can someone please help me out here??? I'm running out of
idea!!!!!!THANK YOU SOOO MUCH!!!!

Dim rdaOleDbConnectString As String = _
"Provider=sqloledb; Data Source=mercury2;Initial" & _
" Catalog=Attendance;User Id=sa;Password="
Dim rda As SqlCeRemoteDataAccess = Nothing
rda = New SqlCeRemoteDataAccess
rda.InternetUrl = "http://i01546/SQLCE/sscesa20.dll"
rda.LocalConnectionString = _
"Provider=Microsoft.SQLSERVER." & _
"OLEDB.CE.2.0;Data Source=\My Documents\ssce.sdf"
rda.Pull("Module", "Select * from Module", _
rdaOleDbConnectString, _
RdaTrackOption.TrackingOnWithIndexes, _
"ErrorTable")

 

[Butt Chin Chuan]

Hi

Have you try to give your virtual directory administrative
permission? I encountered this problem before, and solved
it by setting my virtual directory with administrative
rights. Perhaps you can try that. Hope it helps.