<html>
<head><title></title>
</head>
<%
//设置字符编码
Session.CodePage=936 //936是gb2312的页面编码
Response.charset="gb23121"
Response.Expires = -1
Response.AddHeader "pragma","no-cache"
Response.CacheControl = "no-cache"
Response.Buffer = true
Dim connstr,conn
//connstr = "Provider=SQLOLEDB;Server=(local)\sqlexpress;Uid=sa;Pwd=1234;DataBase=ajax" //sqlserver2005连接语句
connstr = "Driver={mysql odbc 3.51 driver};Server=ADMIN-PC;uid=root;password=123;Database=ss" //mssql连接语句
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connstr
Response.write("数据库连接成功！")
%>
<body>
</body>
</html>
//特别注意,mysql odbc 3.51 driver是一款asp访问mysql的驱动，你需要通过下载安装才能用的，http://www.skycn.com/soft/2141.html，网上很多说的都不对，不能用Provider=SQLOLEDB;Server=(local);Uid=root;Pwd=123;DataBase=ss这样的连接语句
最新评论