不通过dsn访问sql server

不通过dsn访问sql server,不通过dsn访问sql server

在连接字符串里加上服务器和数据库驱动程序就可以了

Example:

dim conn

set conn =Server.CreateObject("ADODB.Connection")

conn.ConnectionString = "driver={SQLServer};"server=yourserver;uid=sa;pwd=pwd;database=pubs"

conn.open

Set cmd= Server.CreateObject("mand")

Set cmd.ActiveConnection = conn