SQL Anywhere Integration with Visual Studio 2005

SQL Anywhere 10 contains a number of integration features with Microsoft Visual Studio .NET (both 2003 and 2005). These features are designed to make it easier to work with a SQL Anywhere database while developing an application using Visual Studio. This whitepaper outlines the integration features that are present with Visual Studio 2005, and contains tutorials demonstrating how the integration features can be used to ease application development while working with a database.

SERVER EXPLORER PLUG-IN
The Visual Studio Server Explorer can be used to display information about databases, such as their schema, and the data they contain. You can also modify the data stored in database tables using the Server Explorer.
OPENING THE SERVER EXPLORER
1. In Visual Studio, choose View > Other Windows > Server Explorer. The Server Explorer appears on the screen, replacing the Toolbox. To switch back to the Toolbox, click the Toolbox tab. If the Server Explorer is docked to the side of your screen, tabs appear along the side.
2. Right-click Data Connections, and then choose Add Connection. The Add Connection dialog appears.
3. If the Data Source is not set to SQL Anywhere (SQL Anywhere 10), click the Change button and select SQL Anywhere from the list.
4. Type SQL Anywhere 10 Demo in the ODBC Data Source name field.
5. In the User ID field, type DBA, and in the Password field, type sql.

Get download pdf SQL Anywhere Integration with Visual Studio 2005

Related Tutorial

Filed Under Database 

Tags: , , , , , , , , , , , , , , , , , , ,

Comments

Leave a Reply