any hint would be appreciated.
1. environment: sql 2000 sp3, sql ce2.0 & sp3, evb, iis
latest, windows xp
2. problem:
i wrote a simple program to test sync. i could call
rda.submitsql successfully.
when i call rda.pull, the program halts, and no error
report. so i logged the error in sscerepl.log. the
database is created ahead with no table at all. also i
can see out file is created temporarily.
3. sscerepl.log
2003/12/11 15:13:10 Hr=00000000 SSCESA20.DLL loaded 0
2003/12/11 15:13:10 Hr=00000BD0 Sync Thread started 1
2003/12/11 15:13:10 Hr=000001CC Pool Thread started 1
2003/12/11 15:13:10 Hr=00000000 Count of active RSCBs
= 1
<STATS Period_Start="2003/12/11 14:08:23"
Period_Duration="3886" Syncs="0" SubmitSQLs="0"
RDAPushes="0" RDAPulls="1" AVG_IN_File_Size="0"
AVG_OUT_File_Size="0" Completed_Operations="0"
Incomplete_Operations="0" Total_Sync_Thread_Time="2"
Total_Pool_Thread_Time_IN="0"
Total_Pool_Thread_Time_OUT="0" Total_Sync_Queue_Time="0"
Total_Pool_Queue_Time_IN="0"
Total_Pool_Queue_Time_OUT="0" />
2003/12/11 15:13:10 Hr=00000BD0 Sync thread exiting 1
2003/12/11 15:14:10 Hr=000001CC Pool thread exiting 1
2003/12/11 15:15:17 Hr=00000000 SSCESA20.DLL loaded 0
2003/12/11 15:15:17 Hr=00000B18 Sync Thread started 1
2003/12/11 15:15:17 Hr=00000A14 Pool Thread started 1
2003/12/11 15:15:17 Hr=80004005 ERR:REQUEST NOT QUEUED
for ulRSCBId = -1
2003/12/11 15:15:17 Hr=00000B18 Sync thread exiting 1
2003/12/11 15:15:17 Hr=00000A14 Pool thread exiting 1
4. code
Private Sub Command1_Click()
Dim rda As SSCE.RemoteDataAccess
Set rda = CreateObject("SSCE.RemoteDataAccess.2.0")
rda.LocalConnectionString = gCEProvider
rda.InternetURL = "http://ipaddr/ppc/sscesa20.dll"
rda.InternetLogin = ""
rda.InternetPassword = ""
On Error Resume Next
rda.Pull "cetest", _
"SELECT * FROM cetest", _
"Provider=SQLOLEDB;Data
Source=sqlserver;Initial Catalog=Northwind;Integrated
Security=SSPI;Persist Security Info=False;", _
TRACKINGOFF
ShowErrors (rda.ErrorRecords)
Set rda = Nothing
App.End
End Sub