10 Years
Discussion Span
Last Post by ~s.o.s~

Ouch, you just hurt my feelings....
Why you not using MySQL, it is more easier to work with (in my opinion). If you wish to stay with MsSQL you need to get your self ODBC connector and learn to use it


You need to download the sql server 2005 jdbc driver (sqljdbc.jar) and make sure it is on the application server/servlet container's CLASSPATH.
An easy way of doing this is to put sqljdbc.jar in your webapps WEB-INF/lib directory.

There is plenty of documentation on MSDN on how to use it. A good basic example is here


do i need a connector???

HI My Friend,
Pl. avoid to connect to database from jsp file using any software. Pl. Write Separate Coding for connect Database in this coding using type 4 driver. it is very easy to connect all database without DSN name creation.

If you connect DATABASE using any database you cannot transfer context any system it is no easy.

So, Pl. Write java coding you connect database server side.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.