asp读取mysql中字段类型为json数据
mysql表t_json中info字段类型为json
如何用asp取出这个json类型数据
我这样读取提示
Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'
[Microsoft][ODBC 驱动程序管理器] 程序类型越界
/api/purchases/conn.asp,行 14
<%
'测试读取MySql数据库的内容
strconnection="driver={MySQL ODBC 8.0 ANSI Driver};database=world;server=127.0.0.1;uid=root;password=Nihaoma@123"
'strconnection="dsn=blaoda;driver={MySQL ODBC 8.0 ANSI Driver};uid=root;password=Nihaoma@123"
'无需配置dsn
set adodataconn = server.createobject("adodb.connection")
adodataconn.open strconnection
strquery = "SELECT info FROM t_json where id=4"
set rs = adodataconn.execute(strquery)
if not rs.bof then
%>
<%
do while not rs.eof
%>
<%=rs("info")%>
<%
rs.movenext
loop
%>
<%
else
response.write("无数据.")
end if
rs.close
adodataconn.close
set adodataconn = nothing
%>