不通过dsn访问sql server

核心提示：在连接字符串里加上服务器和数据库驱动程序就可以了Example:dim connset conn = Server.CreateObject("ADODB.Connection")conn.ConnectionString = "driver={sql server(WINDOW

　　在连接字符串里加上服务器和数据库驱动程序就可以了
Example:
dim conn
set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "driver={sql server(WINDOWS平台上强大的数据库平台)};"server=yourserver;uid=sa;pwd=pwd;database=pubs"
conn.open
Set cmd= Server.CreateObject("ADODB.Command")
Set cmd.ActiveConnection = conn