DSN is outside SQL Server's control so I don't know if a reinstall will help (also, this file is in none of the SQL Server installs I can currently see). What you could do it use a proper type 4 driver then you don't need DNS. [ July 18, 2007: Message edited by: Paul Sturrock ]
Paul, Scott Thanks for your responses. I shall try by modifying SQL_MAX_DSN_LENGTH in sqlext.h and then doing a reinstallation. But this is not a good idea because the program has to be run on the Server machine, where it can run into the same issue.
I shall try to follow paul's idea and check it out.