Re: can i know what software shall i use to connect jsp file to the database?
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
Re: can i know what software shall i use to connect jsp file to the database?
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
Last edited by blater; Apr 25th, 2008 at 10:02 am.
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.
Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.
This thread is more than three months old
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Offline 
Marked 
