MS SQL Server

Hello again..Can anybody help me with the procedure to setup the environment to interact with MS SQL database using servlet?Thanx again..
[158 byte] By [Apya] at [2007-11-26 13:51:15]
# 1
Environment?Like the windows environment?Like the J2EE container environment which is specific to the container itself?Something else?
jschella at 2007-7-8 1:28:27 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
> Can anybody help me with the procedure to setup the> environment to interact with MS SQL database using> servlet?If you mean installing Tomcat, http://www.devx.com/webdev/Article/16416and http://www.moreservlets.com/
aniseeda at 2007-7-8 1:28:27 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3
read the mysql docs regarding usage
SoulTech2012a at 2007-7-8 1:28:27 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 4

If you are looking for pointers on where to start, here it is:

A typical java web environment is a WebContainer like Tomcat server.

See http://tomcat.apache.org

You would need a book/tutorial on how to write servlet that runs in webcontainer.

Once your servlet is up, then you may try connecting to any database vendor. for MS SQL server you would need their JDBC drivers. google tells me u may download here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=6D483869-816A-44CB-9787-A866235EFC7C&displaylang=en

You would need to learn how to get data out using java.sql packages. Read javadoc on these.

Once you got data out of db from servlet, you would typically forward to a JSP page to render a html view of your selected data.

Have fun.

thebugslayera at 2007-7-8 1:28:27 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...