Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Programming » SQL Anywhere Explorer » Using the SQL Anywhere Explorer

Using the SQL Anywhere Explorer Next Page

Working with database connections in Visual Studio .NET


Use the SQL Anywhere Explorer to display the SQL Anywhere database connections under the Data Connections node. You must create a data connection to view the data in the tables and views.

You can list database tables, views, stored procedures, and functions in the SQL Anywhere Explorer and expand individual tables to list their columns. The properties for an object selected in the SQL Anywhere Explorer window appear in the Visual Studio Properties pane.

To add a SQL Anywhere database connection in Visual Studio .NET
  1. Open the SQL Anywhere Explorer by choosing View > SQL Anywhere Explorer.

  2. In the SQL Anywhere Explorer window, right-click Data Connections, and then choose Add Connection.

    The Add Connection dialog appears.

  3. Select SQL Anywhere, and then click OK.

    The Connection Properties dialog appears.

  4. Enter the appropriate values to connect to your database.

  5. Click OK.

    A connection is made to the database, and the connection is added to the Data Connections list.

To remove a SQL Anywhere database connection from Visual Studio .NET
  1. Open the SQL Anywhere Explorer by choosing View > SQL Anywhere Explorer.

  2. In the SQL Anywhere Explorer window, right-click the data connections you want to remove, and then choose Delete.

    The connection is removed from the SQL Anywhere Explorer window.