Khởi chạy Windows Control Panel và sau đó chọn Administrative Tools ➪ ODBC. 2. Trong hộp thoại ODBC Nguồn dữ liệu Quản trị viên, nhấp vào một trong hai DSN người dùng hoặc tab System DSN. Chọn tab System DSN nói chung là một ý tưởng tốt, nguồn dữ liệu của bạn sau đó sẽ được hiển thị cho người dùng khác trên máy tính của bạn. | 362 Part VIII Appendixes__ 1. Launch the Windows Control Panel and then choose Administrative Tools ODBC. 2. In the ODBC Data Source Administrator dialog box click either the User DSN or System DSN tab. Selecting the System DSN tab is generally a good idea your data source is then visible to other users on your computer. 3. From the list of drivers pick either the SQL Native Client or the SQL Server driver. The SQL Native Client is the more current connectivity driver so I recommend that you select this option. 4. Enter the name and description of your connection pick the server and click Next. 5. Choose the authentication method you want and click Next. 6. Choose your default database and click Next. 7. Fill in the final settings and click Finish. 8. Test your new ODBC connection. The SQL Native Client offers a very useful feature to help validate that your connection was set up correctly. Just click the Test Data Source button shown in Figure B-8 to launch this verification utility. Figure B-9 show a successful connection. With these last steps out of the way you can now confidently start using your SQL Server 2005 Express database. Figure B-8 Summary of ODBC settings. Appendix B Migrating to SQL Server 2005 Express 363 Figure B-9 A successful connection. 366 Part VIII .
