Check in the connection design wizard to see which radio button is checked in the "Display ODBC login prompts" section. If 'Always' is set, you will always be prompted for the login parameters. The appropriate setting you need is most likely, 'When login information is not specified'. If that's what you have and it's still prompting, then your DSN is probably not configured correctly.