Ask a Teacher

Search



how to do a database connectivity program?

The features that make up Visual Studio Team Edition for Database Professionals make use of one or more database connections. Before you can connect to a database, you must create the connection. You can create a connection by clicking New Connection in the following dialog boxes:
  • Data Compare dialog box
  • Schema Compare dialog box
  • Connect to Database dialog box for the Transact-SQL (T-SQL) editor
  • Generate Data for Target Database dialog box for Data Generator
  • Database Test Configuration dialog box for database unit testing


To add a connection by clicking New Connection

  • Click New Connection.
  • The Connection Properties dialog box appears.
  • In Server Name, type or click the name of the server to which you want to connect.
  • To use your Microsoft Windows credentials to log on to the server, click Use Windows Authentication.
  • To use SQL Server authentication to log on to the server, click Use SQL Server Authentication, and then type your user name and password in User name and Password.
  • In Connect to a Database, type or click the name of the database to which you want to connect.
  • (optional) You can click Advanced to configure advanced connection properties.
  • (optional) You can click Test Connection to verify that you can connect to the database by using the specified connection information.
  • Click OK to create the connection.


comments powered by Disqus