Certain versions of SQL Server (6.5 I know, others maybe) don't
enable TCP/IP access by default. Contact your DBA for more assistance.
Randy
> -----Original Message-----
> From: Jack Li [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 18, 2001 11:24 AM
> To: 'Tomcat Users List'
> Subject: RE: JDBC Driver for MS SQL Server
>
>
> 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]>
>
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
