Creating the ODBC
Click Start> Run> and in the text box type 'odbcad32'. You should already be in the 'User DSN' tab so click on 'Add'.
Another window should pop-up.
You'll have to scroll all the way down to the bottom and select 'SQL Server' then click 'Finish'.
Another window/form will pop-up needing information for your new Data Source.
Fill in the details:
Name: GunzDB
Description: <Leave this blank>
SQL Server:
Open SMSE* and
look below the 2nd icon which disconnects you from the data engine (located at the top left).
You should see something like this:
COMPUTERNAME\SQLEXPRESS
Copy this down into the SQL Server box.
After that, click next since the settings are already configured.
Secondly, select
With SQL Server authentication using a login ID and password entered by the user.
Username: sa
Password: <the password you configured>
Thirdly, select
Change the default database to and select GunzDB from the drop-down menu and click next.
Finally, click Finish.
If you would like to check your data source, click 'Test Data Source...' in the window or you can just click 'OK' to finish. Now to completely finish it, click 'OK' again.