How to configure data source using ODBC administrator?

You can start ODBC Administrator applet by executing command ODBCCP32.CPL via Start > Run, or you can open it from Control Panel. When you start ODBC Administrator, you will see several tabs, here I explain for you.
User DSN:- Data sources that are available only on the local computer to the current user.
System DSN:- Data sources that are available to any user on the local machine.
File DSN:- Data sources that are stored in files. These files can be saved on network shares and used by multiple users on multiple machines.
Drivers:- A list of the installed drivers with version numbers.
Tracing:- Options for logging of ODBC calls on the local machine. The feature is very useful for debugging. But it extracts a performance penalty for overhead and creates very large trace files if it is left on for too long.
Connection Pooling:- Settings that allow a connection to stay available after it has been closed in order to improve efficiency. You can configure how long the connection will remain available after it has closed.
About:- Names and version numbers of all core components.
Please note that not all tabs will be available on all platforms or with all versions of ODBC.
Let’s say you want to create a data source to your SQL Server, and then follow these settings.
1. On the User DSN tab, click Add. The choose SQL Server and click Finish.
2. Enter the name for the data source, a brief description of the data source, and then the name of the server, which can be typed or chosen from the drop-down list. Click on Next.
3. Choose the appropriate authentication method for the server. Click on client configuration to see how the server connection will be made. Make sure the connect to SQL Server to obtain default settings option is checked. This allows ODBC to select the correct default codepage translation and language information for the client. Click on the Next.
4. The wizard connects to the SQL Server and figures out what databases you have access to. On the next screen, choose to connect to the “pubs” database by default. The other options on this screen deal with how the connection will handle some very specific ODBC stuff. Click on Next.
5. The next screen is dedicated to the topics of internationalization and logging performance data. The internationalization settings won’t need to be changed here in the U.S., but elsewhere these will need to be modified to suit the local environment. The settings for logging performance data enable you to save queries that urn for a long time so they can be optimized, as well as to log statistics. Click on Next.
6. The last screen allows you to test the data source. Run the test to ensure that the data source has been installed.