[java]MSSQL 서버 Connection

사용/설치법
http://support.microsoft.com/default.aspx?scid=kb;ko;313100

 

드라이버 다운로드
세부정보 : http://www.microsoft.com/korea/sql/downloads/SQL_Server_2000_Driver_for_JDBC_SP3.asp
Window기반 드라이버 : http://download.microsoft.com/download/4/1/d/41d3e9c0-64d1-451e-947b-7a4cba273b2d/setup.exe
Linux기반 드라이버 : http://download.microsoft.com/download/4/1/d/41d3e9c0-64d1-451e-947b-7a4cba273b2d/mssqlserver.tar

참고) DriverManager를 기준으로 한 Connection

MSSQL :
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://IP주소입력(211.58.154.204):1433", "아이디", "비밀번호");

ORACLE :
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@IP주소(211.58.154.204):1521:DB명(orcl)", "아이디", "비밀번호");

 

[출처]