473,326 Members | 2,113 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Replication to SQL with VB 2005

Hi all! Having a major quandry and looking for some support. Please
help.

Here's the goal:
* PocketPC device gathers various data and needs to merge with
Enterprise SQL Server
* I have the replication working at home, but I need to migrate to
another computer, but suddenly I am getting the wonderful 80072EFF
error.

I have researched this for days and it appears that the 80072EFF error
is due to lack of internet connectivity, which is odd as I have a solid
internet connection through the PocketPC when connecting through
Microsoft ActiveSync.

Currently, I am utilizing a SQL Server 2000 SP4 merge publication with
the SQL Mobile device as an anonymous subscribers. I have the SQL
Agent running message when using "http://[IP
Address]/ARC_PUSH/sqlcesa30.dll."

What I tried to do is disconnect my Internet connection and try to
replicate data directly through the MS Activesync connection, but this
is not working. Here is the snippet from my code in VB 2005:

<<DB Creation Code>>
Cursor.Current = Cursors.WaitCursor
' Determines if a DB exists, if so, it deletes it and
rebuilds.
If File.Exists(LOCALDATABASE) Then
If MessageBox.Show("Are you sure you wish to create a
new database? WARNING: This will delete any existing data.", _
"Warning", MessageBoxButtons.YesNo,
MessageBoxIcon.None, MessageBoxDefaultButton.Button1) =
Windows.Forms.DialogResult.Yes Then
File.Delete(LOCALDATABASE)
Else
Cursor.Current = Cursors.Default
Exit Sub
End If
End If

engine.CreateDatabase()
ReplicateData()

Cursor.Current = Cursors.Default
MessageBox.Show("Replica database created", _
"Replicated", _
MessageBoxButtons.OK, _
MessageBoxIcon.None, _
MessageBoxDefaultButton.Button1)

<<ReplicateData Function>>
'Sets parameters for replication
Dim replicator As New SqlCeReplication()
replicator.InternetUrl = INTERNETURL
replicator.Publisher = PUBLISHERSERVER
replicator.PublisherDatabase = PUBLISHERDATABASE
replicator.PublisherSecurityMode = _
PUBLISHERSECURITYMODE
replicator.Publication = PUBLICATION
replicator.Subscriber = SUBSCRIBER
replicator.SubscriberConnectionString = _
CONNECTIONSTRING
replicator.Synchronize()

The values are set through an .ini file that I created. If the cable
is plugged in and I change to the IP address of the LAN, it works fine.
If I unplug the cable and change the IP address to the Activesync
connection. It bombs.

Any ideas?

Mark

Apr 18 '06 #1
0 980

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: steve | last post by:
Hi, several years ago , I implemented the oracle replication system. At that time our database was ported from an old Fox pro application. ( K , no laughing at the back). As the foxpro...
2
by: randi_clausen | last post by:
Regarding a new replication process using two Windows 2000 servers at 5.00.2195, one machine with SP4 and the other SP3, and both running WSE 8.1.5., I am requesting assistance. My dilemma--It...
1
by: Andy K | last post by:
Hi , Finally i was able to setup my replication process between two databases . For those who were not following my story , i was trying to setup a replication between two databases on...
9
by: David W. Fenton | last post by:
See: Updated version of the Microsoft Jet 4.0 Service Pack 8 replication files is available in the Download Center http://support.microsoft.com/?scid=kb;en-us;321076 This includes the Jet 4...
1
by: loosecannon_1 | last post by:
All my queries are being blocked while the tables are being replicated and it is causing some 2 minute blocking. Is there a way for the Replication to allow dirty reads because I really don't...
1
by: miller.brettm | last post by:
Hello, I'm getting the following error message when I try add a row using a Stored Procedure. "The identity range managed by replication is full and must be updated by a replication agent". ...
11
by: Anthony Paul | last post by:
Hello everyone, I am involved in a scenario where there is a huge (SQL Server 2005) production database containing tables that are updated multiple times per second. End-user reports need to be...
3
by: bourgon | last post by:
I'm getting this, after upgrading from 2000 to 2005. Replication-Replication Distribution Subsystem: agent (null) failed. The subscription to publication '(null)' has expired or does not exist....
13
by: John | last post by:
Hi We have an MS Access application which runs on the server but some laptop users need the app to work offline. Our solution has been to use Access replication which automatically syncs data...
2
by: zgb | last post by:
Hi, I'm using MS SQL server 2005. I have two identical databases - with one exception: they have different names (etc database1 and databse2), but their structure is completely same. Is it...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
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 using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.