Scenario 2: .NET via SQL Server
This scenario shows a .NET application using the SQL Server Provider connecting to RMS on VMS via a SQLServer linked server and SQLServer on Windows. This .NET application indirectly uses CONNX via SQL Server linked server technology.
With CONNX, a legacy data source is accessed as if it were just another relational table. The user can create stored procedures and other routines as if the disparate data sets all belonged to the same database. CONNX provides the seamless connectivity and access to the legacy data source.
In this scenario, the CDD is on the user's machine. This is typical in a development environment, where CDD changes are stored on the user's local machine, and propagated to the server when development is complete. In the production environment, move the CDD closer to the CONNX Client, or to a dedicated file server.