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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-13 : 07:51:23
|
| steveb frierdich writes "I am trying to develop a vb application that will do database replication from a database on a pc that does not have sql server 7.0 installed on it to a database on a pc that does sql server 7.0 standard edition installed on it. Can you provide me with any website that has complete example code in vb for a vb application that can be used on the pc that does not have sql server 7.0 on it to replicate the database and transfer the updates to the database located on the pc with sl server 7.0 installed on it. I have isolated 4 dlls from sql server 7.0 that provide some vb ax controls that can be used in a vb app, but it seems that one is missing. I have the dlls for the Microsoft Distrubution Control, the Microsoft Merger Control, the Microsoft Replication Error Control, and the Microsoft Transaction Library Control, but I can not seem to isolate the Microsoft Snap Action Control? Can you tell maybe what files I need for this control and maybe direct me to some real vb code that uses these controls for replication from a PC with out sql server 7.0 installed on to one that has sql server 7.0 installed on it. I also looked at using the SQL-DML object library but the files I exported sql server 7.0 to the computer without sql server 7.0, these files could not be registered making it so the object libray could not be imported in the VB app. Can you possibly see what I may be doing wrong and also can SQL-DMO also be used to do replication?I tried the samples for repication that came with the SQL server 7.0 but they do not work for one reason or another. And without any real documentation on these examples to guide me step by and providing solutions on when a error occurs,and be a begginer at sql server 7.0, these examples are pretty much worth less.I have also spent come considerable time searching the web for code examples but most of all the code I found was worthless and just sniplets of different things, or it was advertisement for books. Thank you for you time.Steve" |
|
|
|
|
|
merge or immediate transaction replication from a database on a pc that does not have sql server 7.0