DSN Creation gives error

DSN stands for Data Source Name.And this is how it is created. In the control panel, you have the administrative tools here there is a ODBC driver click on it & then follow the steps. the last step is to test the connection & this is were i am getting an error saying "test case failed ". Can anyone help, its very urgent