SQL Server 2005 JDBC driver v1.2 Aug CTP is LIVE
The Microsoft SQL Server JDBC team is proud to announce the availability of our v1.2 CTP2 (beta) release. The driver is downloadable at https://msdn.microsoft.com/data/jdbc. The direct link to the download page is https://www.microsoft.com/downloads/details.aspx?FamilyID=f914793a-6fb4-475f-9537-b8fcb776befd&DisplayLang=en
In this CTP release, we added SSL encryption support to the driver on top of the Adaptive response buffering support available in CTP1.
Jimmy Wu, SQL Server
Disclaimer: This posting is provided "AS IS" with no warranties, and confers no rights
Comments
Anonymous
September 04, 2007
PingBack from http://msdnrss.thecoderblogs.com/2007/09/05/Anonymous
September 05, 2007
SQL Server 2005 JDBC Driver 1.2 CTP August 2007公開Anonymous
October 09, 2007
Have some problems with the sqljdbc.jar versions 1.1 and 1.2 with Vista. If we use the jdk 1.4 we get the error "The SQL Server login requires an SSL connection." If we use the jvm 1.6 we are able to get a connection. Are there some know problems with Vista and this driver and different versions of the jvm? Have narrowed down the code to the basic which I will now include. import java.sql.*; public class testSqlServer2 { /**- @param args */ public static void main(String[] args) { // TODO Auto-generated method stub try { java.lang.Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); Connection c = java.sql.DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=mydb;user=testadmin;password=admin;SelectMethod=cursor "); System.out.println("We have connection!"); } catch (Exception ex){ ex.printStackTrace(); } } } rkbean@gmail.com
Anonymous
October 12, 2007
The comment has been removedAnonymous
October 18, 2007
Hi Yesim , Recently I downloaded version 1.2 release of the Microsoft SQL Server 2005 JDBC Driver. Thanks a ton to Microsoft for providing many new features such as Adaptive Buffering , SSL Encryption , Tightly Coupled XA Transactions etc. I am mainly concerned about SSL part of it and would be grateful if you can solve my queries or forward it to app- ropriate forum. 1 ) I tried connecting to SSL enabled SQL Server 2005 through a sample program provided by Microsoft along with this package ( Version 1.2 ) and I succeeded whereas in previous versions I use to get an exception as "The SQL Server login requires an SSL connection." My connection string is as follows "jdbc:sqlserver://Ip adress of dataserver machine:1433;databaseName=master;user=sa;password=sapassword" . Ideally we should only get an SSL connection when we request it else an error message should be thrown informing the user that dataserver requires an SSL connection. This would help in choosing between type of communication a user needs with dataserver. The scenario now is like forcing a user to have SSL communication if dataserver forces it. A flag may be added as ssl should be mandatory or auto . 2 ) Current driver 1.2 is not capable of communicating with MS SQL Server 2000 both in case of SSL and Non - SSL cases , The error which we receive in both cases is : Oct 18, 2007 4:57:17 PM com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin WARNING: ConnectionID:1 TransactionID:0x0000000000000000 Prelogin response packet not marked as EOM The TDS protocol stream is not valid. To communicate with both MS SQL Server 2000 and 2005 a user will have to maintain both the drivers which may increase complexity of the application , like loading both driver in a single process , etc etc . . . If version 1.2 id built on top of Sql server 2000 JDBC drive then it should be able to handle following 4 cases : i ) SQL Server 2005 - SSL , ii ) SQL Server 2005 - Non - SSL , iii ) SQL Server 2000 - SSL , iv ) SQL Server 2000 - Non - SSL . If this single driver handles all above 4 cases , life of a developer and application developed by him/her would become less complex. 3 ) Last but not the least , the SQL Server 2000 JDBC driver connects with both kind of SQL Server 2000 instances i.e. SSL and Non - SSL without any certificate of flags specified. I was able to establish non - SSL connection with SQL Server 2000 using two third party JDBC drivers which I think is not appropriate behaviour. 4 ) I have also noticed that when SQL Server 2005 is running in Non - SSL mode i.e. "ForecEncryption=No" and our Client application requests SSL communication , we are not warned about server is not runnning in SSL mode , could you please explain this ? Kindly correct me I am wrong anywhere as I am just a beginner and don't have much knowledge on this subject . Thanks a lot. Sincerly , Sudhansu TiwariAnonymous
October 21, 2007
Please ignore 2 and 3 above. I Identified the issue related to 2 and 3 above , SP4 for SQL 2K wasn't properly intstalled on my system , hence a re-installation did the trick. Thanks.Anonymous
October 29, 2007
The comment has been removedAnonymous
April 13, 2008
Hi, I have downloaded the driver to install for SQL SERVER 2005 Express. sqljdbc_1.0.809.102_enu.exe But when I try to open it as instructed, I get an error message that the program is not a valid win32 application. Please Advise, Regards, DafnaAnonymous
April 13, 2008
Any reason you are donwloading the 1.0 driver. You should down load 1.2 driver. http://www.microsoft.com/downloads/details.aspx?FamilyID=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en Mugunthan[MSFT]Anonymous
September 09, 2008
The comment has been removedAnonymous
September 09, 2008
The comment has been removedAnonymous
November 13, 2008
The comment has been removedAnonymous
November 20, 2008
Hello, My trying to connect to SQL Server 2005 from a UNIX machine but I get an error. The configuration setings that I use are: Driver:com.microsoft.jdbc.sqlserver.SQLServerDriver URL:jdbc:microsoft:sqlserver://<serverName>:<portNumber>;databaseName=<myDataBase>;SelectMethod=Cursor The eror message is: Failed to open input block: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (""): Data type 0x38 is unknown. Any one can help? Thanks. Regards, Miguel