Sorry , guys ... I was trying to connect to the server and had the ODBC on my machine i.e the client instead of the server just did it on the server and it worked fine.

Thanks for the help.