Groups | Blog | Home
all groups > sql server replication > march 2006 >

sql server replication : Problems with replicaion to JET 4.0 subscribers


Duncan Tilley
3/14/2006 9:44:49 PM
Hi,

I have a couple of queries I wonder if anyone can help me with.


Merge replcation to Access with Merge ActiveX control.
Using MSDE subscriber, takes about 30 secs to download schema and
data.Using Access, takes about 5 minutes, and the file size is about 5
times what I would expect. Data is correct, though. Is this just
excessive freespace being allocated?

JET 4.0 Transactional replication subscriber.
I have set up a linked server to act as a subscriber. I can access the
subscriber database via the linked server, and apparently add it as a
subscriber via 'Configure Publishers / Subscribers' - but when trying
to set up a push subscription, it does not show as an enabled
subscriber.
I set up the linked server via sp_addlinkedserver, set rpc on in both
directions and collation compatible with sp_serveroption, and set the
login to the linked server to 'Admin'
I've obviously missed a trick, but I cant see what it is...


Many thanks for your help

Duncan Tilley
Hilary Cotter
3/16/2006 7:21:59 AM
Is this publication enabled for jet subscribers? I suspect it is not.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

Duncan Tilley
3/16/2006 2:31:57 PM
On Thu, 16 Mar 2006 07:21:59 -0500, "Hilary Cotter"
[quoted text, click to view]

Hi Hilary

Thanks for the reply.

Err, yes, you're right... Now I feel stupid...

Many Thanks

Duncan
AddThis Social Bookmark Button