Connecting to MS SQL server from Java
[192 byte] By [ninad_ka] at [2007-10-1 3:04:49] 
hi ,I am trying to connect to MS SQL Server from Java (Jsp).Where can i get the driver fro connection and What will be the syntax for connection.Thanks in advance..
You can get a free JDBC 2.0 driver from Microsoft, but it's quite buggy.I would recommend jTDS ( http://jtds.sourceforge.net/ ). It's a JDBC 3.0 implementation, much faster and way more stable. Mind you, I'm one of the developers.Alin,The jTDS Project.
SAfe13a at 2007-7-8 21:36:06 >
> You can get a free JDBC 2.0 driver from Microsoft,
> but it's quite buggy.
>
> I would recommend jTDS ( http://jtds.sourceforge.net/
> ). It's a JDBC 3.0 implementation, much faster and
> way more stable. Mind you, I'm one of the
> developers.
But other people not associated with it, seems to think it works pretty good too. Comments suggest that usually, and even perhaps always, better than the MS one.
jschella at 2007-7-8 21:36:06 >
Database Connectivity New Topic
- question on sqlserver?
- error of Exception:java.sql.SQLException: ResultSet is closed
- Can I use DDL in JDBC(see detail in Message)
- long prepared statements
- java.net.SocketExceptionMESSAGE: Software caused connection abort: recv fai
- problem with JDBC
- ORA-00997:illegal use of LONG datatype
- sqlserver autonumber IDENTITY column
Database Connectivity Hot Topic
- ORACLE: OCI: 17008 Connection Closed on DriverManager.getConnection
- Command Window Database Access via a DataSource (Pt 2)
- question on payment gateway?
- default value for column in a view ?
- Why can't I connect to MS Access by JDBC in some windows platform?
- Fail to convert to internal representation error !
- cstmt.setTimestamp with a NULL value
- OT - Replicating Data to other sites
Database Connectivity
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding