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 1 4626
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 Sign in to post your reply or Sign up for a free account.
Similar topics
by: turnit \(removethis\) |
last post by:
I have a login form that uses the post method to carry the
information to the next page. The form works just fine in
ie6.0, but fails in mozilla and fails in ie5.2 on a
mac. "HTTP/1.1 400 Bad...
|
by: MKPrasad |
last post by:
Hi,
We are running ASP application in our Production
environment on "Windows 2000 Advanced Server" SP4 , IIS
5.0.
Occationally We see a IIS crash,
with the following info on Event Log...
|
by: Daniel Rimmelzwaan |
last post by:
I want to send a biztalk document to an aspx page, and I need to see some
sample code, because I just can't make it work. I have a port with transport
type HTTP, pointing to my aspx page, something...
|
by: eswanson |
last post by:
I have a web page I need to post a file plus some other fields to it. How
can I do this from a asp.net page. I know I can send individual fields to the
other page, but how do I send a file to the...
|
by: Ammar |
last post by:
Dear All,
I'm facing a small problem.
I have a portal web site, that contains articles, for each article, the end
user can send a comment about the article.
The problem is:
I the comment length...
|
by: AnalogKid17 |
last post by:
Keywords:
ASP.NET app with VS2005 running on Win2003 with IIS6, and SQL2000 on a
WinXP Box
I've betting the following for days... it's driving me insane:
Server Error in '/' Application.
...
|
by: tyakimov |
last post by:
Hi guys
I got a problem
On my IIS server I changed the password for the Internet Guest Account
'IUSR_Machine' and suddenly the PHP part of the intranet stopped
working. - '... failed to open...
|
by: Henry Stock |
last post by:
I am trying to understand the following error:
Any thing you can tell me about this is appreciated.
Security Exception
Description: The application attempted to perform an operation not allowed...
|
by: mouac01 |
last post by:
My site uses lots of AJAX requests to PHP files which then retrieves
data from MySQL. About 95% of the time the requests complete without
issues. Every once in a while a request will hang for...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |