Using the SQL Anywhere Explorer

In Visual Studio, you can use the SQL Anywhere Explorer to create connections to SQL Anywhere databases. Once you connect to a database, you can:

  • view the tables, views, and procedures in the database
  • view the data stored in tables and views
  • design programs to open connections with the SQL Anywhere database, or to retrieve and manipulate data
  • drag and drop database objects onto C# or Visual Basic code or forms so that the IDE automatically generates code that references the selected object

You can also open Sybase Central and Interactive SQL from Visual Studio by choosing the corresponding command from the Tools menu.

Installation note

If you install SQL Anywhere software on a Windows computer that already has Visual Studio installed, the installation process detects the presence of Visual Studio and performs the necessary integration steps. If you install Visual Studio after installing SQL Anywhere, or install a new version of Visual Studio, the process to integrate SQL Anywhere with Visual Studio must be performed at a command prompt as follows:

  • Ensure Visual Studio is not running.
  • At a command prompt, run install-dir\Assembly\v2\setupVSPackage.exe.

Working with database connections in Visual Studio
Configuring the SQL Anywhere Explorer
Adding database objects using the SQL Anywhere Explorer
Working with tables using the SQL Anywhere Explorer
Working with procedures and functions using the SQL Anywhere Explorer

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0