컴퓨터/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");