After I put the three jar files in TOMCAT_HOME/lib. The classes were found. But I got new error: "No suitable driver ". What is the TCP/IP port for SQL Server? Here is my program:
String m_Class = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; String m_Connector = "jdbc:microsoft.sqlserver://prodserver:1433"; String m_Username = ""; String m_Password = ""; Connection con = null; try{ Class.forName(m_Class); con = DriverManager.getConnection(m_Connector, m_Username, m_Password); }catch(ClassNotFoundException e){ out.println("class not found: " + e.getMessage()); }catch(SQLException e){ out.println(e.getMessage()); }catch(Exception e){ out.println(e.getMessage()); } thanks for your help Jack -----Original Message----- From: Guido Medina [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 10:31 AM To: 'Tomcat Users List' Subject: RE: JDBC Driver for MS SQL Server TOMCAT_HOME/lib -----Original Message----- From: Jack Li [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 11:30 AM To: '[EMAIL PROTECTED]' Subject: JDBC Driver for MS SQL Server Hi, I am using Tomcat 3.2.1. I downloaded the JDBC Driver for MS and Installed it. But I got error: "Unable to load class com.microsoft.jdbc.sqlserver.SQLServerDriver". Where to put the three jar files? Also, are there other drivers available and good? I am using jdbc-odbc to connect SQL Server now. My application freezes very oftenly. Any sugguestions? Thanks, Jack -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>