asp连接mysql5,怎么连?
来源:百度知道 编辑:UC知道 时间:2024/06/08 00:12:55
在网上找了N多资料试过了都不行,用DSN连接是成功的,但到程序里面就不行了。请回答者留下QQ号!方便提供在线解答。急!!
<%
dim dbtype
'dbtype = "mssql" '链接mssql数据库
'dbtype = "MySQL" '链接mysql数据库
dbtype = "access" '链接access数据库
dim strconn
'## dsn
'strconn = "dsn=my_dsn_name"
'## ms access 2000 using virtual path
'strconn = "provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("/ssgbook/ssgbook.mdb")
'## ms access 2000
'strconn = "provider=microsoft.jet.oledb.4.0;data source=e:\site\asp\ssgbook\ssgbook.mdb"
'## ms access 2000
strconn = "driver={microsoft access driver (*.mdb)}; dbq=" & server.mappath("ssgbook.mdb")
'## 链接 ms SQL Server 2000 & 7
'strconn = "driver={sql server};server=server_name;uid=uid;pwd=pwd;database=dbname"
'## 链接mysql数据库
'strconn = "driver=mysql;server=server_name;uid=