VB Prodigy Tutorial (continued)---Configure a SQL Server data source

This article welcomes the non-commercial use of reprint, but need to indicate from the "Programming Network" and the corresponding URL link.

To configure a SQL Server data source:

(1) Open the ODBC Data Source Manager in Control Panel and click the Add button to add a data source.

(2) After clicking the Add button, the system prepares to add a user data source. To install the data source, the Create New Data Source window pops up, as shown in the following figure. Because of the serial nature of VB and SQL Server, SQL Server is also listed in the Create New Data Source window even if the user does not have SQL Server installed. Of course, the list items here only play a role in labeling, if the user has not installed SQL Server, please install the following steps.

(3) After you select SQL Server in the figure above, click Finish to enter the Create a new data source to SQL Server window, as shown in the following illustration:

▲ Type a new data source name in the name item, where we type SQL Server1 as the new data source name.

▲ Type a description of the data source in the description item, which you can not fill out here.

▲ Type the SQL Server server you want to connect to in the server item. If the SQL Server that you want to connect to is installed on this computer, select Local from the Drop-down box, which indicates the server that is connected to the locality. If the SQL Server you want to connect to is installed on a different server, select the appropriate option from the Drop-down box. If you select a server name from the list, no more configuration is required. If you enter the name of a non-existent server as an entry in SQL Client Configuration utility, you can create a server alias for the new name on the next screen of the wizard.

▲ Click the Finish button to complete the configuration of the new data source. Click the Next button to configure your next step.

▲ How should SQL Server verify the authenticity of the login identification number? "Below are two single options for users to choose from.

▲ Specify the login identification number used by the SQL Server driver when connecting to SQL Server if you select Use SQL Server authentication with user input login identification number and password. This applies only to connections that determine the default configuration of the server, not to subsequent connections using the created data source.

▲ Specify the password that SQL Server uses when connecting to SQL Server if you select Use SQL Server authentication with user input login ID and password. This applies only to connections that determine the default configuration of the server, not to subsequent connections using a new data source.

(5) Click the Next button to verify the connection. If correct, the connection is successful, otherwise the system will indicate a specific error and the user should verify the correctness of the input.

See a full set of "VB Prodigy Tutorials" (continued)