Subscriber computer is MSDE 2000 and is able to synchronize with our SQL Server 2005 machine (Publisher) with no problems. I'm working to automate this process and from my "development" machine I can connect to the subscriber, load a MergePullSubscription, get the SynchronizationAgent and call Synchronize() on it...no problems.
However (isn't there always a however?), when I try to run this from our subscriber, production machine, my application would crash with no errors saying an assembly could not be found, but would not tell which one. AND it did not throw an exception to tell me which assembly was missing. I found that I needed to install Native Client and Management Objects and all seemed well...until I got to the code where I tried to get the SynchronizationAgent property from the merge pull subscription. Now I get this error:
Microsoft.SqlServer.Replication.ComErrorException (0x80040154): Class not registered
at Microsoft.SqlServer.Replication.MergeSynchronizationAgent..ctor()
at Microsoft.SqlServer.Replication.MergePullSubscription.get_SynchronizationAgent()
at ReplicationSync.Form1.btnStart_Click2(Object sender, EventArgs e) in ...
I have spent hours trying to figure out what's different on my development machine (with Visual Studio and MSDE, etc) and I'm lost. I did find a post where they mentioned registering sqldistX.dll & sqlmergX.dll, but this did not fix the problem.
Am I missing some install here?
I have found what is missing. Within ...\Microsoft SQL Server\90\COM\ folder, I had only a resources folder and NO .dll files. I found that the missing class Id is from a file (sqlmergx.dll) in this folder on my development machine which has 25 .dll files including sqlmergx.dll and sqldistx.dll. However, I found that I had to register all of these .dll files for my solution to work (not just those 2).
I guess what I need to know now is what redistributable package adds these files to the folder listed above. Does anybody know what install adds these files?
|||Is there anybody who knows what install, installs these files?
No comments:
Post a Comment