Folks have reported good results with the JSQLConnect driver from NetDirect. http://www.j-netdirect.com/JSQLFeatures.htm
Cheers, Bill -- William G. Thompson, Jr. Chief Japple Evangelist | www.japple.org Saucon Technologies [EMAIL PROTECTED] | +1 908 947 7145 | www.saucontech.com On Tue, 16 Jul 2002, Turner, John wrote: > > 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]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
