option button and then use the System Database button to locate the database. in .NET framework

Creating Code 128A in .NET framework option button and then use the System Database button to locate the database.

Page Timeout. Specify a time limit for completing ODBC operations. The Buffer Size. Specify the number of bytes available for ODBC buffering. The

A

Exclusive. Select this option if the application requires exclusive use of the data-

database. such as a user name and password. Keep in mind that anyone authorized to use the system can also use this DSN. If your database is secured, you might not want to supply a user name and password here. ODBC prompts for any required user name and password when you don t define them in the DSN.

Advanced. Click this button if using the database requires additional settings,

If you have several applications that use the same database, you should use the same System DSN for all of them. That way, if you ever have to move, rename, or reconfigure the database, you only have one System DSN to update. If you need to establish a System DSN on a Web server and you don t have access to your Web server s console, someone who does have access will need to set up the System DSN for you. On a corporate intranet, contact your departmental administrator or MIS department. For Internet service providers, contact the support staff or system administrator.

Like Access, Microsoft SQL Server is an ODBC-compliant database. If SQL Server drivers are available on your PC, you can use ODBC for opening SQL Server databases in Access. If SQL Server drivers are available on your Web server, Microsoft Active Server Pages can read 1237

A

Microsoft Office Access 2003 Inside Out SQL Server databases via ODBC. Here s the procedure for defining an ODBC System DSN for a SQL Server database:

2 Open Windows Control Panel. 3 Double-click the Administrative Tools shortcut. In Administrative Tools, double-click

select SQL Server, and then click Finish. This starts the Create a New Data Source to SQL Server Wizard, the first window of which is shown in Figure A-13.

sample database on the local MSDE server.)

is the name that ultimately appears in the Name column of the ODBC Data Source Administrator window (Figure A-10).

ning. If the computer name doesn t appear in the drop-down list, type it in. Use (local) to point to the server on your machine.

8 Click Next to see the second window of the wizard, shown in Figure A-14.

You might need to ask your SQL Server administrator how to fill in these values, which are as follows:

With Windows NT authentication using the network login ID unless the data-

base administrator has instructed you to use an SQL Server login ID and password. Select With SQL Server authentication using a login ID and password entered by the user if you re using SQL Server s built-in security.

Figure A-14. Settings related to SQL Server communication and security. Client Configuration. Click this button to select the type of network library

Connect to SQL Server to obtain default settings for the additional configuration options. To obtain defaults from the server specified in the previous dialog box, select this check box. If the server uses SQL Server login IDs, you ll also need to supply a login ID that has administrative rights and a password. Click Next to continue.

Figure A-15. Selecting a default database and connection options. Change the default database to. When you use Windows NT authentication,

the default database for the user is typically the master catalog database. You must select this option and choose the actual database that you want from the drop-down list. When you use an SQL Server login ID, you can leave this option set to the default, and the user will have the option to select another database when using this DSN.