the request to send data to the computer running IIS has failed. for more information

[krndhi1983]

Hi to All,
I am using Windows XP running IIS 6.0.I am developing a project using vb.net 1.1 with SQL Server 2000.It is a mobile project.So i am also using Pocket PC 2002 with SQL CE 2.0.When I want to Pull the table from SQL Server 2000 to SQL CE the following error will be occured.
The Error is the request to send data to the computer running IIS has failed. for more information see HRESULT.MS Active Sync4.0 also been installed in my s/m.I have been run this project Pocket PC 2002 Emulator. The database also been stored in my s/m.

Any One can help Me to solve this Problem ?



Private ssceConn As SqlCeConnection = Nothing
Private strDataSource As String
Friend rdaOleDbConnectString As String

' Initialize the RDA object.
Friend rda As SqlCeRemoteDataAccess = Nothing
'Find Application Path
Friend runtimeFolder As String = System.IO.Path.GetDirectoryName(System.Reflection. Assembly.GetExecutingAssembly().GetName().CodeBase )

Private Sub CreateLocalDatabase_ServerConnection()
Dim sqlEngine As New SqlCeEngine("Data Source=" + runtimeFolder + "\mobiledb.sdf")

sqlEngine.CreateDatabase()

MsgBox("Database Created")

rdaOleDbConnectString = "Provider=sqloledb; Data Source=GOFRUGAL-FD468D;Initial Catalog=Mobiledb;User Id=sa;Password=sa"

rda = New SqlCeRemoteDataAccess("http://192.168.1.90/karuna/sscesa20.dll", "Administrator", "GFT", "Data Source=" + runtimeFolder + "\mobiledb.sdf")

Call TablePull()
End Sub



Private Sub TablePull()
Try

rda.Pull("tocheck", "SELECT * FROM tocheck", rdaOleDbConnectString, RdaTrackOption.TrackingOffWithIndexes, "ErrorTable")

rda.Pull("whilecheck", "SELECT * FROM whilecheck", rdaOleDbConnectString, RdaTrackOption.TrackingOffWithIndexes, "ErrorTable")

MsgBox("Smart Device pull Succeeded.")

Catch Errstr As SqlCeException
Dim i As Integer
For i = 0 To Errstr.Errors.Count - 1
MsgBox(Errstr.Errors(i).ToString)
Next

Finally
rda.Dispose()
End Try
End Sub




Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim MsgResult As Boolean
If File.Exists(runtimeFolder + "\mobiledb.sdf") Then
MsgResult = MsgBox("Continue Existing Data!", MsgBoxStyle.Question.YesNo, "Data Pull From Server") = MsgBoxResult.Yes
If MsgResult = False Then
File.Delete(runtimeFolder + "\mobiledb.sdf")
Call CreateLocalDatabase_ServerConnection()
End If
Else
Call CreateLocalDatabase_ServerConnection()
End If
End Sub

[krndhi1983]

the request to send data to the computer running IIS has failed. for more information
--------------------------------------------------------------------------------

Hi to All,
I am using Windows XP running IIS 6.0.I am developing a project using vb.net 1.1 with SQL Server 2000.It is a mobile project.So i am also using Pocket PC 2002 with SQL CE 2.0.When I want to Pull the table from SQL Server 2000 to SQL CE the following error will be occured.
The Error is the request to send data to the computer running IIS has failed. for more information see HRESULT.MS Active Sync4.0 also been installed in my s/m.I have been run this project Pocket PC 2002 Emulator. The database also been stored in my s/m.

Any One can help Me to solve this Problem ?



Private ssceConn As SqlCeConnection = Nothing
Private strDataSource As String
Friend rdaOleDbConnectString As String

' Initialize the RDA object.
Friend rda As SqlCeRemoteDataAccess = Nothing
'Find Application Path
Friend runtimeFolder As String = System.IO.Path.GetDirectoryName(System.Reflection. Assembly.GetExecutingAssembly().GetName().CodeBase )

Private Sub CreateLocalDatabase_ServerConnection()
Dim sqlEngine As New SqlCeEngine("Data Source=" + runtimeFolder + "\mobiledb.sdf")

sqlEngine.CreateDatabase()

MsgBox("Database Created")

rdaOleDbConnectString = "Provider=sqloledb; Data Source=GOFRUGAL-FD468D;Initial Catalog=Mobiledb;User Id=sa;Password=sa"

rda = New SqlCeRemoteDataAccess("http://192.168.1.90/karuna/sscesa20.dll", "Administrator", "GFT", "Data Source=" + runtimeFolder + "\mobiledb.sdf")

Call TablePull()
End Sub



Private Sub TablePull()
Try

rda.Pull("tocheck", "SELECT * FROM tocheck", rdaOleDbConnectString, RdaTrackOption.TrackingOffWithIndexes, "ErrorTable")

rda.Pull("whilecheck", "SELECT * FROM whilecheck", rdaOleDbConnectString, RdaTrackOption.TrackingOffWithIndexes, "ErrorTable")

MsgBox("Smart Device pull Succeeded.")

Catch Errstr As SqlCeException
Dim i As Integer
For i = 0 To Errstr.Errors.Count - 1
MsgBox(Errstr.Errors(i).ToString)
Next

Finally
rda.Dispose()
End Try
End Sub




Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim MsgResult As Boolean
If File.Exists(runtimeFolder + "\mobiledb.sdf") Then
MsgResult = MsgBox("Continue Existing Data!", MsgBoxStyle.Question.YesNo, "Data Pull From Server") = MsgBoxResult.Yes
If MsgResult = False Then
File.Delete(runtimeFolder + "\mobiledb.sdf")
Call CreateLocalDatabase_ServerConnection()
End If
Else
Call CreateLocalDatabase_ServerConnection()
End If
End Sub