interesting and strange internet-replication issue...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alexander Becker - 19 Apr 2004 10:15 GMT

Hello,

i set up internet replication and get the following strange behaviour:
when synchronizing thru AccessXP-UI
1. open the client DB with AccessXP
2. do a internet-sync with the managed hub-replicat -> yields an error
3685: invalid http-address
3. do step 2 exactly again: replication works fine
4. do step 2 x times again: replication works fine
5. close and re-open the db and sync: error 3685 again, then it works again
like step 2

strange, uh?
the same behaviour is with DAO-Programming.
I tried this with IP-Address and with hostname, both failing. (yes, i
reconfigured replman and created a new replset for the hostname-test)

My system-config:
DB: Access2002 format
Server: Win2000 Server SP3, ReplMan 4.0, MDAC 2.60.6526.3, JET4.0 SP8
Client: Win2000 Professional SP3, MDAC 2.60.6526.3, JET4.0 SP8

Another strange thing: then starting internet synch with DAO.Synchronize, it
only works in VB6-IDE-Debug mode.
In EXE-Runtime it fails with error 3685 but works most time when an
messagebox or inputbox is placed directly before the synchronize-command.
It seems to has nothing to do with focus-issues, because open another form
and placing the focus on this form does not help.

I hope anyone can provide a solution....
Next thing i'll try is installing MDAC 2.7

thanks,
Alexander Becker

Reply to this Message

Alexander Becker - 19 Apr 2004 13:28 GMT

Hello again,

i've installed MDAC 2.71.9040.2 now and re-applied Jet40SP8.
Now, the behaviour inside Access is the same (replications fails the first
time after opening the db)
But Replication via DAO / JRO / TSI-Sync40 fails everytime, dont't know
why....
Everytime Invalid HTTP-Address, but it's valid, sure!
I've even checked MSysTranspAddress:InternetAddress, tried with http://
prefix and without, with trailing slash and without...
No matter what i do, it doesnt work...
But, in principial the setup has to work, why else could the access IDE
synchronize without errors after the first try?

strange....alex.

Reply to this Message

Alexander Becker - 19 Apr 2004 13:45 GMT

Hello,

this is a sample-code which i used to test the internet-sync.
The first internet sync fails, the second direct sync works well, the third
fails, the fourth fails, too...
So, unlike within the Access-IDE a second sync does not "fix" the problem...

alex.

Private Sub TestSync()
Dim conn As ADODB.Connection
Dim db As JRO.Replica

Set conn = New ADODB.Connection
With conn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Properties("Jet OLEDB:System database") =
"C:\StartP\STARTPL.ORG\JF.SPP\JF-MDW.MDW"
.Properties("User Id") = "xxxx"
.Properties("Password") = "xxxx"
.Properties("Data Source") = "C:\StartP\STARTPL.ORG\JF.SPP\JF-User.MDB"
End With

Set db = New JRO.Replica
conn.Open
db.ActiveConnection = conn
db.Synchronize "http://jf-s1.jf-do1.local", jrSyncTypeImpExp,
jrSyncModeInternet
db.Synchronize "\\jf-s1\startps.org\jf.spp\jf-user.mdb", jrSyncTypeImpExp,
jrSyncModeDirect
db.Synchronize "http://jf-s1.jf-do1.local", jrSyncTypeImpExp,
jrSyncModeInternet
db.Synchronize "http://jf-s1.jf-do1.local", jrSyncTypeImpExp,
jrSyncModeInternet

Set db = Nothing
conn.Close
Set conn = Nothing

End Sub

Reply to this Message

Alexander Becker - 19 Apr 2004 18:45 GMT

Hello again :-)

i tested the synchronisation with ReplicationManager on the client-side too.
Both Internet and Indirect synchronizations worked perfect......
But, the problems with DAO / JRO / Synch40 remained :-(

no more ideas :-(((
alex.

Reply to this Message

Steve - 27 Apr 2004 21:25 GMT

Alex,

It sounds like we are facing similar issues. See my post on 4/27/04.

Steve

Reply to this Message

Thomas Lowery - 28 Apr 2004 16:25 GMT

Wow... I am seeing a lot of people with the same problem,
but can find no one with even a remote answer. MDAC 2.8
worked somewhat for me for a while, (I have a master and
about 25 to 30 replicas), but eventually it started in
again with the Invalid HTTP address. Only does it on some
machines, and not all the time. Can find no rhyme or
reason to it... please keep me in the loop if any of you
find SOME type of answer.

Thanks,

Thomas Lowery

>-----Original Message-----
>Alex,
[quoted text clipped - 4 lines]
>
>.

Reply to this Message

Alexander Becker - 29 Apr 2004 09:22 GMT

Hi Thomas,

> Wow... I am seeing a lot of people with the same problem,

yes, but many of them really make failures like
DB.Synchronize(http://address/path/to/database.mdb, dbsynchinternet)
which will fail with error "Invalid HTTP-Address", too...
But, i found many other postings which were really based on our problem,
too.

> but can find no one with even a remote answer. MDAC 2.8
> worked somewhat for me for a while, (I have a master and

Do you really think MDAC has something to do with it?
I thought the newer MDAC Versions does not contain JET at all?!? Would it be
worth a try?
I've used MDAC 2.71.9040.2 in my tries...

so long, alex.

Reply to this Message