RE: JDBC Driver for MS SQL Server

[Guido Medina]

Try now checking the name of the driver, very detail checking, the case of
the letters, the dots and son for example, maybe instead of
com.microsoft.jdbc.sqlserver.SQLServerDriver is
com.microsoft.jdbc.sqlserver.SQLServer.Driver, try navigating the jar files
of the driver, and check the folders, you have to see
com/microsoft/jdbc/sqlserver...etc etc, check every detail, if you don't
find any error try e.printStackTrace() to see what is happenning instead of
e.getMessage(), the first is more detail, check the user, normally could be
admin and empty passwd, etc etc, that's all I can tell you now.

Your welcome (you said thank you),

Guido.

-----Original Message-----
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 12:12 PM
To: 'Tomcat Users List'
Subject: RE: JDBC Driver for MS SQL Server


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]>