Replication on multiple clients

One Server and many clients .
How do I set it up that my clients can replicate with my server.
ie Create the replication.
I am using foxpro as my front end and sql server as my back end.
With SQL Server I can use Enterprise Manager to create the pull subscribtion
..
Work well.
But
the clients don't have SQL Server but get the free MSDE.
I can create the databases and such using foxpro and sql exec commands but
how do I setup the replication.
Is anonymous pull connections safe or must I use named connections.
How do I setup the named pull subscriptions automatically.( via sql
commands)
Thanks in advance
Robert Craill
Web Development
USP Designs (Pty) Ltd
E: robert@.cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za
USP Designs (Pty) Ltd is Proudly South African!
This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.
No reply's
Is my request so idiotic
"Robert Craill" <robert@.cyberprop.com> wrote in message
news:uwj3LZ$zFHA.1028@.TK2MSFTNGP12.phx.gbl...
> One Server and many clients .
> How do I set it up that my clients can replicate with my server.
> ie Create the replication.
> I am using foxpro as my front end and sql server as my back end.
> With SQL Server I can use Enterprise Manager to create the pull
> subscribtion .
> Work well.
> But
> the clients don't have SQL Server but get the free MSDE.
> I can create the databases and such using foxpro and sql exec commands but
> how do I setup the replication.
> Is anonymous pull connections safe or must I use named connections.
> How do I setup the named pull subscriptions automatically.( via sql
> commands)
> Thanks in advance
> ----
> Robert Craill
> Web Development
> USP Designs (Pty) Ltd
> E: robert@.cyberprop.com
> T: +27 11 955 9100
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
> USP Designs (Pty) Ltd is Proudly South African!
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>
|||Hi Robert, you can use replication system stored procedures to set up
replication in your case. The documentation for
sp_add[merge]pullsubscription[_agent] should be able to get you started.
HTH
-Raymond
"Robert Craill" wrote:

> No reply's
> Is my request so idiotic
> "Robert Craill" <robert@.cyberprop.com> wrote in message
> news:uwj3LZ$zFHA.1028@.TK2MSFTNGP12.phx.gbl...
>
>