RE: JDBC Driver for MS SQL Server

[Jack Li]

Hi,
Now, After I put three jar files in tomcat/lib, program is able to locate
the classes. But I have another error:

"[Microsoft][SQLServer JDBC Driver]Error establishing socket."

What is it?

Here is the progrm:

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,

Jack

-----Original Message-----
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 10: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]>