แก้ไข JAVA JDBC MSSql connection ไม่ได้
แก้ไข JAVA JDBC MSSql connection ไม่ได้ Download latest MSSQL JDBC driver from here: http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx Referenced the 2 JAR files in my project: sqljdbc.jar and sqljdbc4.jar (I'm not yet sure if both of the above are required or just one..) Make sure the SQL Server Browser windows service is running Open SQL Server Configuration Manager and go to Protocols for SQLEXPRESS under SQL Server Network Configuration . Right-click on TCP/IP and choose Properties. Set Enabled = YES. While you're there, click on IP Addresses tab and find the section IP All . Set TCP Port to 1433. Add sqljdbc_auth.dll to your PATH Environment Variable . In my case: D:\Java\sqljdbc_4.0\enu\auth\x64 Copy the sqljdbc_auth.dll to your JDK directory . In my case: C:\Program Files\Java\jdk1.7.0_04\bin I hope this h...