Logo 
Search:

Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

Create connection to a SQL Server 2000 database

  Asked By: Abbie    Date: Feb 01    Category: Java    Views: 1030
  

I'm a newbie developer wanting to use Tomcat to develop an ecommerce
application but the client needs to use the SQL Server 2000. So, I am
still wondering how to make the connection to that database from my
JSP files.

If someone could send me an URL or write down here the steps to get
that done, I would appreciate it a lot.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Alvin Nguyen     Answered On: Feb 01

I haven't worked so much with Tomcat , but firstly, you should download
the JDBC driver ,there are different jdbc drivers availbale on the
internet JNet or microsoft jdbc driver .Secondly, set the CLASSPATH for
3 JDBC jar files and finally enjoy using the database  . I don't know
that tomcat offer connection  pools if so thhen you can make a
connectoin pool for it and get it by calling JNDI . or doing the
traditional work of making connection and statement and executing a
query.

 
Didn't find what you were looking for? Find more on Create connection to a SQL Server 2000 database Or get search suggestion and latest updates.




Tagged: