Now we get to the good stuff... I have provided some helpful screenshots to guide you on your DSN creation.
Go into Control Panel:
Then Administrative Tools:
Then ODBC Data Sources:
Then click on the System DSN tab and click on Add:
You see a bunch of tabs at the top these tabs are different things to do with ODBC. User DSN are DSN's for a specific user, but for a web server you shouldn't create DSNs in here; use them for internal pages for you only. System DSN: the whole system can see these, and they are ones that everyone that accesses your computer can see.
Choose your driver:
Here you can choose any of the available database drivers on your machine. Choose the one for accessing the type of database you will be using. If you are running SQL Server, here you choose the SQL Server Driver, and you have to supply server addresses, passwords, usernames, database names, etc.
Set up the DSN:
- Enter a Data Source Name; this is what we call your Database, so keep it short and without spaces. eg. myBooks
- Click on Select... to browse to the directory where your database is and choose it. This tells ODBC where to find the DB.
- If you set a password for your database, click on Advanced....
Access only supports passwords, not usernames, so just enter the password and click OK.
Click OK to the other dialog and you can see your DSN listed in the System DSN list, and now you can use it to set up databases.