Hi-
I wrote an app years ago using jsp, and life has been good, it just
hummed along quietly passing the password and username in the
connection string ex:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con =
DriverManager.getConnection("jdbc:odbc:old_way","user_name","pass_word");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM blah blah blah....");

now we have a new database that needs windows authentication.

I built a new ODBC data source using the new server and windows
authentication and it connects fine. (lets call it new_way)

QUESTION: How do I code the new ODBC source?

("jdbc:odbc:new_way","user_name","pass_word");
("jdbc:odbc:new_way","","");
("jdbc:odbc:new_way");

all above give me the following error:

javax.servlet.ServletException: [Microsoft][ODBC SQL Server Driver]
[SQL Server]Login failed for user '(null)'. Reason: Not associated
with a trusted SQL Server connection.

HELP!

Thanks in advance

dharper@research.umass.edu