Requirements for Using Replication ActiveX Controls in Development Environments
This section explains how to use the SQL Distribution control, SQL Merge control, and SQL Snapshot control in Microsoft Visual Basic and Microsoft Visual C++ development environments.
Important
The replication ActiveX controls are deprecated in favor of Replication Management Objects (RMO) for programming in managed code. If you call the ActiveX controls from managed code, you must use .NET Framework 2.0 or an exception is thrown.
Microsoft Visual Basic
To use one or more Microsoft ActiveX replication controls in a Visual Basic program: on the Project/References menu in the Visual Basic Development Environment, in the References dialog box, select the .dll references for the controls you plan to use.
| Component | Reference | Library |
|---|---|---|
SQL Distribution Control |
Microsoft SQL Distribution Control 9.0 |
sqldistx.dll |
SQL Merge Control |
Microsoft SQL Merge Control 9.0 |
sqlmergx.dll |
Replication Errors |
Microsoft SQL Replication Errors 9.0 |
replerrx.dll |
For a default installation of SQL Server 2005, these files are located in C:\Program Files\Microsoft SQL Server\90\COM\.
Microsoft Visual C++
To use the one or more replication controls in a Visual C++ program, use the #import directive to import the files from the Libraries column of the following table in the appropriate source files of your project.
| Component | Libraries |
|---|---|
SQL Distribution Control |
sqldistx.dll |
SQL Merge Control |
sqlmergx.dll |
Replication Errors |
replerrx.dll |
Reference these files in your project or NMAKE file. For a default installation of SQL Server 2005, these files are located in C:\Program Files\Microsoft SQL Server\90\COM\.
After the controls are referenced, they can be included in the Components toolbar; however, these controls are not user interface controls. Drawing the controls on the form will not instantiate them. The controls need to be instantiated with the NEW keyword. In addition, a variable of the ActiveX object's class can be declared using the WithEvents keyword. This enables the program to receive callbacks from the agents, and the application can cancel the ActiveX object in this callback function. The callback is also available with the SQLReplError Object, although it is a notify callback and not a status callback.
See Also
Reference
Replication ActiveX Control Reference
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
14 April 2006 |
|