conn.ConnectionString = "driver={SQL Server};">

不通过dsn访问sql server

80酷酷网    80kuku.com

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















分享到
  • 微信分享
  • 新浪微博
  • QQ好友
  • QQ空间
点击: