Migrating to SQL Server 2005 Express

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.