컴퓨터/JAVA
HOW TO: Get Started with microsoft JDBC
Hikasiru
2006. 5. 4. 09:30
link: http://support.microsoft.com/default.aspx?scid=kb;en-us;313100
link: http://support.microsoft.com/default.aspx?scid=kb%3Bko%3B313100
Set your system CLASSPATH variable to include the following entries:
• \Your installation path\Lib\Msbase.jar
• \Your installation path\Lib\Msutil.jar
• \Your installation path\Lib\Mssqlserver.jar
To Pass the Connection URL
con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433", "userName", "password");
Ex)
"jdbc:microsoft:sqlserver://127.0.0.1:1433;DataBaseName=TEST;SelectMethod=Direct;User=admin;Password=sa");