不通過dsn訪問sql server

在連接字符串里加上服務器和數據庫驅動程序就可以了Example:dim connset conn = Server.CreateObject("ADODB.Connection")conn.ConnectionString = "driver={SQL Server};"server=yourserver;uid=sa;pwd=pwd;database=pubs"conn.openSet cmd= Server.CreateObject("ADODB.Command") Set cmd.ActiveConnection = conn