Pull Method in SqlCE - Help Please RRS feed

  • Question

  • User-531104354 posted
    Hi, I am trying to use RDA Pull in my application. here is the sample code Dim ServerOledbStr As String Dim rda As SqlCeRemoteDataAccess rda = New SqlCeRemoteDataAccess ServerOledbStr = "Provider=sqloledb; Data Source=local; Initial Catalog=Northwind;User Id=sa;Password=testing123;" rda.LocalConnectionString = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0; Data Source=tempdb.sdf; Password=testing123" rda.InternetUrl = "http://localhost/SQLCEServer/sscesa20.dll" rda.InternetLogin = "domainname\test22" rda.InternetPassword = "test22" Try rda.Pull("Employees", "Select * from Employees", ServerOledbStr, RdaTrackOption.TrackingOnWithIndexes, "ErrorTable") Catch ex As SqlCeException Dim curExNdx As Int32 For curExNdx = 0 To ex.Errors.Count MessageBox.Show("Error:" & ex.Errors(curExNdx).ToString) Next Finally End Try I am using integrated windows authentication, I have IIS and SQL server running on the same machine. I am getting this error message "Error:System.Data.SqlServerCE.SqlCEerror:A request to send data to the computer running IIS has failed. For more inforamtion see HRESULT [,,,,,]" If I display nativeerror, the error number is 28037. Could you please help me to solve this problem? Thanks a lot!
    Tuesday, May 18, 2004 2:21 PM

All replies

  • User-531104354 posted
    I resolved this one! Thanks!
    Friday, May 21, 2004 12:12 PM