Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravikumarsv
Starting Member
12 Posts |
 Posted - 2008-03-07 : 12:52:00
|
| Hi All,I have a problem replicating data from Subscriber to Publisher.I configured Queued updatable subscriptions in transactional replication. Publisher is on SQL Server Standard edition and Subscriber is on SQL Server Express edition, both on Windows XP. When I insert/update data in publisher, the data is replicated to subscriber. If I insert/update data on subscriber the data is not replicated. When I see the replication monitor for errors, it shows an error "Cannot load a DLL xprepl.dll or one of its resources".Could any one give me a solution or please tell me if I missing something?Thanks you all,Ravi. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-07 : 13:14:31
|
| May be Express Edition Doesn't support updatable subscriptions.Are you able see that DLL in Bin folder? |
 |
|
|
ravikumarsv
Starting Member
12 Posts |
Posted - 2008-03-08 : 12:45:14
|
| I read an article yesterday, it says that SQL Server Express can subscribe to merge, transactional, and snapshot publications. Merge replication and transactional replication with updating subscriptions both allow changes to be propagated from Subscribers back to the Publisher.Please look into this link http://msdn2.microsoft.com/en-us/library/ms143470.aspxI can see the DLL in Binn folder, when i tried register it with regsvr32 it throws an error "LoadLibrary('D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xprepl.dll') failed - The specified module could not be found". |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
|
|
ravikumarsv
Starting Member
12 Posts |
Posted - 2008-03-09 : 04:29:40
|
| Yes, both the versions of SQL are same SQL Server 2005 and updated with latest service pack (SP2), but editions are different Publisher is configured on SQL Server 2005 Standard Edition and Subscriber is configured on SQL Server 2005 Express Edition. I can see the xprepl.dll in Binn folder, but unable to register it. Error is thrown while registering the DLL "LoadLibrary('D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xprepl.dll') failed - The specified module could not be found."I uninstalled the SQL Express edition and installed it again and configured the replication. Same error is replicated again.Don't know how to get out of this error.Thanks,Ravi. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-09 : 10:49:54
|
| SQL Server express edition doesn't have SQL Server agent.SO how can replication job work to replicate back to publisher. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-09 : 10:52:52
|
| It looks like you miss this part:http://msdn2.microsoft.com/en-us/library/ms151819.aspx |
|
|
|
|
|
|
|
|
Problem with Queued Updatable subscriptions