I am currently trying to set up Tomcat 4.1 server to use connection pooling (jndi)to access a MS SQL 2000 database. I am able to successfully set up connection to Oracle database but I am not having any luck with MS SQL 2000. Could someone Please explain to me what I need to do to successfully set up and test the connection.
Get the JDBC driver from microsoft's site. look at the attached documentation for the exact url format. Worked for me before.
Thanks for the help. I have looked at the ms site, downloaded and installed the driver but I am still not able to get the connection to work. Do you know where I can obtain a sample server.xml file that has the connection ms sql setup already. I would like to look at the file to make sure what I am doing is correct. I believe my url setup might be the problem.