I′m developing an pocket pc application, I need replicate using two
publications.
My main form has two button, first button to obtain data from a publication
and the second button to obtain data from the other.
I delete my local PDA DB, and I can only obtain data from one of the
publication associated with the first button I push. When I push the other
one, I get
the "typical" error "Inicializing SQL reconciler has failed...".
Can I have only one DB publication associated with the PDA?
Any help would be appreciated.
Inma
SQL 2000 CE only supports a single publication per database. SQL 2005
CE/Mobile supports more than 1.
Hilary Cotter
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
"inma" <inma@.discussions.microsoft.com> wrote in message
news:304E1356-B953-486E-866B-48F01B923D98@.microsoft.com...
> Im developing an pocket pc application, I need replicate using two
> publications.
> My main form has two button, first button to obtain data from a
publication
> and the second button to obtain data from the other.
> I delete my local PDA DB, and I can only obtain data from one of the
> publication associated with the first button I push. When I push the other
> one, I get
> the "typical" error "Inicializing SQL reconciler has failed...".
> Can I have only one DB publication associated with the PDA?
> Any help would be appreciated.
> Inma
Showing posts with label publications. Show all posts
Showing posts with label publications. Show all posts
Tuesday, March 27, 2012
Sunday, February 19, 2012
error subscribing to publication
Hi All,
[CURRENT SET UP]
I have two SQL 2k Ent servers in two locations.
SVR1 has 2 publications (snapshot and merge) the SVR2 subscribes to.
SVR2 republishes these, so that a number of local MSDE clients can
subscribe to them.
SVR1 also has a number of local MSDE subscribers.
[PROBLEM]
Everything was working great, however this afternoon I tried to add a new
MSDE subscriber (through enterprise manager on my machine, as opposed to
SVR1) to SVR1 and got the following message ?
SQL Server Enterprise Manager could not retrieve information about the
publications from Publisher 'SVR1'.
Error 208: Invalid object name 'syspublications'.
Invalid object name 'sysextendedarticlesview'.
I really don't want to drop publications on this server, and so am trying
to find a way of solving this problem, rather than redeploying the
replication structure.
Any help in understanding or troubleshooting this would be greatly
recieved !
TIA.
Ranjeet.
oddly, if I script a subscription and run it, all is OK.
It appears enterprise manager in trying to enumerate the publications is
failing, and so preventing me from subscribing users through EM.
Does anyone know how the publications are enumerated - is there a view /
table / SP that exists for this ?
TIA
Ranjeet.
[CURRENT SET UP]
I have two SQL 2k Ent servers in two locations.
SVR1 has 2 publications (snapshot and merge) the SVR2 subscribes to.
SVR2 republishes these, so that a number of local MSDE clients can
subscribe to them.
SVR1 also has a number of local MSDE subscribers.
[PROBLEM]
Everything was working great, however this afternoon I tried to add a new
MSDE subscriber (through enterprise manager on my machine, as opposed to
SVR1) to SVR1 and got the following message ?
SQL Server Enterprise Manager could not retrieve information about the
publications from Publisher 'SVR1'.
Error 208: Invalid object name 'syspublications'.
Invalid object name 'sysextendedarticlesview'.
I really don't want to drop publications on this server, and so am trying
to find a way of solving this problem, rather than redeploying the
replication structure.
Any help in understanding or troubleshooting this would be greatly
recieved !
TIA.
Ranjeet.
oddly, if I script a subscription and run it, all is OK.
It appears enterprise manager in trying to enumerate the publications is
failing, and so preventing me from subscribing users through EM.
Does anyone know how the publications are enumerated - is there a view /
table / SP that exists for this ?
TIA
Ranjeet.
Labels:
current,
database,
ent,
error,
locations,
merge,
microsoft,
mysql,
oracle,
publication,
publications,
server,
servers,
snapshot,
sql,
subscribes,
subscribing,
svr1,
svr2,
upi
Subscribe to:
Posts (Atom)