Working with database connections in Visual Studio

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
  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.

  3. Select SQL Anywhere, and then click OK.

  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
  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.