Data Access String to SQL DB

Is it possible to include in an Excel query all the connection attributes (Server name, userid, password, etc.) so a spreadsheet can be updated by any user without the user having to have the ODBC connection set up?

EXAMPLE: I have a spreadsheet that I post on an intranet server that all users have access to. The data comes from an SQL database and populates the spreadsheet when the Refresh data button is executed. Works fine when I do it, because I am the author and have ODBC set up connecting to the SQL server. How can the general user be able to refresh the data?

Any help on providing the connect string is greatly appreciated!!!!

This can help:
http://www.connectionstrings.com/