我写的语句如下:
Dim sConnection, Conn , objRS 'SERVER为数据库主机名(本地主机用localhost,远程用IP地址);DATABASE为数据库名;UID为用户名;PASSWORD为密码 sConnection = "DRIVER={mysql odbc 3.51 driver}; SERVER=58.64.162.184; DATABASE=my10080; my;PASSWORD=sz123; OPTION=3" Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open(sConnection) '以下SQL语句为示例语句,请根据实际情况修改 Set objRS = Conn.Execute("SELECT jieshao,tupian from wangzhanzhi where id=1") While Not objRS.EOF 'while...wend循环,用于读取所有的信息 Response.Write objRS.Fields("jieshao") & ", " & objRS.Fields("tupian") & " objRS.MoveNext '记录集指针下移 Wend %> |
出的错误如下:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'
[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且