I have a Apache TOMCAt 5 server running as my web server and I would like to connect my web app to a MS SQL database, can anyone help me out on how to connect my MS SQL with the Web app which is running on my TOMCAT web server.
TOMCAT+Apache is running in Linux system. MS SQL is running in windows system
You need the download the proper versions of the MySQL JDBC drivers from http://www.mysql.com/downloads/api-jdbc-stable.html. Then if you already have mySQL installed you just need to connect to the database. Some sources recommend configuring
the database as a JNBI, others say you should be able to open mysql straight from the linux terminal. Specific instructions can be found here: http://www.mulesoft.com/tomcat-mysql