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.

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.

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.

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