<%
dim conn
set conn=server.createobject("ADODB.connection")
con.open "PROVIDER=SQLOLEDB;DATA SOURCE=SQL服务器名称或IP地址;UID=sa;PWD=数据库密码;DATABASE=数据库名称
%>
dim conn
set conn=server.createobject("ADODB.connection")
con.open "PROVIDER=SQLOLEDB;DATA SOURCE=SQL服务器名称或IP地址;UID=sa;PWD=数据库密码;DATABASE=数据库名称
%>
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String login="sa";
String password=your password
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DataBaseName=your daabase name";
Connection conn=DriverManager.getConnection(url,login,password);
createStatement stmt=conn.createStatement();
%>