我安装完了驱动MySQLODBC3.51Driver并且数据源设置完毕系统dsn设置如下:datesourcename:mysqldescription:MySQLODBC3.5.1DriverDSNserver:localhostuser:rootpassword:(空)datebase:...
我安装完了 驱动MySQL ODBC 3.51 Driver 并且数据源设置完毕
系统dsn设置如下:
date source name :mysql
description:MySQL ODBC 3.5.1 Driver DSN
server:localhost
user:root
password: (空)
datebase:wan (数据库wan.sql)
接下来我写了一段代码测试:
strconnection="dsn=mysql;
driver={mysql odbc 3.51 driver};
server=localhost;uid=root;pwd=;database=wan"
set conn = server.createobject("adodb.connection")
conn.open strconnection
sql = "select * from my"
set rs = conn.execute(sql)
if not rs.bof then
%>
username | adduser |
do while not rs.eof
%>
rs.movenext
loop
%>
else
response.write("sorry, no data found.")
end if
rs.close
conn.close
set conn = nothing
set rs = nothing
%>
iis运行错误:
错误类型:
Microsoft VBScript 编译器错误 (0x800A0408)
无效字符
/index.asp, line 11
strconnection="driver={mysql odbc 3.51 driver};
浏览器类型:
Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0)
网页:
GET /index.asp
这是为什么呢?
希望高手翻译系下:
strconnection="dsn=mysql;
这段的意思。
最好
strconnection="dsn=mysql;
driver={mysql odbc 3.51 driver};
server=localhost;uid=root;pwd=;database=wan"
set conn = server.createobject("adodb.connection")
conn.open strconnection
sql = "select * from my"
set rs = conn.execute(sql)
if not rs.bof then
给这段翻译了 谢谢!
展开