Condividi tramite

SQL Server 2005 JDBC driver v1.2 Aug CTP is LIVE

  • Articolo

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 removed

  • Anonymous
    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 Tiwari

  • Anonymous
    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 removed

  • Anonymous
    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, Dafna

  • Anonymous
    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 removed

  • Anonymous
    September 09, 2008
    The comment has been removed

  • Anonymous
    November 13, 2008
    The comment has been removed

  • Anonymous
    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