Connecting to a SQLFire Distributed System

Use SQLFire.NET Designer to create, modify and delete connections to vFabric SQLFire distributed systems.

Prerequisites

Before you follow this procedure:

Procedure

To connect to a SQLFire system:
  1. Start Visual Studio 2008.
  2. Select View > Server Explorer to open the Server Explorer window.
  3. Right-click the Data Connections node and choose Add Connection.... to display the Add Connection dialog.
  4. Click Change... to display the Change Data Source dialog.
  5. In the Data provider menu, select .NET Framework Data Provider for SQLFire and click OK.
  6. In the Server field, anter the hostname and port of the SQLFire server or locator to which you want to connect (for example, localhost:1527).
  7. Click Test Connection to verify that you can connect to the SQLFire system.
  8. Click OK to create the connection. A SQLFire node is added to the Data Connections node.

The connection settings are saved for future use. You can use the saved connection to design or edit tables, columns, indexes, foreign keys, constraints, views, and triggers.