The database technology used with servlets and JSP pages is called JDBC. It is similar to ODBC. Servlets and JSP pages need JDBC drivers to access databases. There are different kinds of JDBC drivers. The different kinds of drivers are explained here: http://www.jguru.com/faq/view.jsp?EID=691
You will need to either use the JDBC-ODBC bridge driver, or purchase a full-JDBC driver from a third-party vendor. The JDBC drivers supplied by Microsoft work with SQL Server 2000 only. For reference, you can get the JDBC driver for SQL Server 2000 here: http://msdn.microsoft.com/downloads/default.asp?URL=/downloads/sample.asp?ur l=/msdn-files/027/001/779/msdncompositedoc.xml In your case, with SQL Server 7, you will need to buy a Type 4 JDBC driver or use the JDBC-ODBC bridge driver, which provides your JSP pages with the JDBC interface they need, but "translates" that into an ODBC interface that SQL Server 7 (and 6.5 and MS Access) can understand. Sun provides a JDBC-ODBC driver, all you have to do is call it, something like this: String driverName = "sun.jdbc.odbc.JdbcOdbcDriver"; String driverURL = "jdbc:odbc:someDataSourceName"; Connection conn = null; Statement stmt; ResultSet rs; String sql; // setup connection Class.forName(driverName); conn = DriverManager.getConnection(driverURL); // setup and execute SQL stmt = conn.createStatement(); sql = "select * from SomeTable"; stmt.execute(sql); // get result set rs = stmt.getResultSet(); You would want more error checking, for example putting the connection, statement, and statement execute code each into their own try/catch block, but hopefully you get the idea. John Turner [EMAIL PROTECTED] -----Original Message----- From: Renee Moussa [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 5:15 AM To: [EMAIL PROTECTED] Subject: tomcat and sql server 7.0 Dear Sir /Madam i'm new to tomcat i already installed the tomcat server and started to build a small application using jsp my problem is i need to connect to sql server 7.0 but i'm not able to find the correct driver where can i download it ? and how do i configure it to be used with tomcat best regards renee Moussa Netiks -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
