Hi,
I had the same problem.the main problem is when u r using MS SQL Server,u will b connected to a server.Basically,in Oracle,username would b scott and password would b tiger.Here, the user name and password would b "sa".If u r working on a standalone machine(u r personal PC),then u can give the username and password as "sa".If u r working in a network,then u need to connect to the server first.After u get connected,type username and password as "sa".
In u r program as well,give the username and password as "sa". What I would suggest u is write a simple java program with .java extension.import java.beans in it.That would make it a bean.Write u r sql code there.
In the JSP,use this tag on the top
<jsp:useBean id="somei.d." scope="session" class="package.BeanClassName" />
Whenever u want to access the function of the bean,use beanid.function() to call u r function.

I hope it's too confusing.

*** One more important thing....When u create an ODBC driver,create it in the SystemDSN tab.Don't create it in the userDSN tab.U may ignore the above said lines,but don't ignore this....
I hope it works....All the best....