windows 主机怎么连接mysql数据库？

jearol

ASP 和 ASP.NET 的代码是什么？
有没有高手解答一下！
谢谢了！感激不尽！！！

bamboo

嗯。。。这个问题。。。

add.c

使用ASP/ADO to 连接MySQL Database.

1. <%
   
2. Dim oConn, oRs
   
3. Dim qry, connectstr
   
4. Dim db_name, db_username, db_userpassword
   
5. Dim db_server
   
6. 
   
7. db_server = "mysql.secureserver.net"
   
8. db_name = "your_dbusername"
   
9. db_username = "your_dbusername"
   
10. db_userpassword = "your_dbpassword"
    
11. fieldname = "your_field"
    
12. tablename = "your_table"
    
13. 
    
14. connectstr = "Driver={MySQL ODBC 3.51 Driver};SERVER=" & db_server & ";DATABASE=" & db_name & ";UID=" & db_username & ";PWD=" & db_userpassword
    
15. 
    
16. Set oConn = Server.CreateObject("ADODB.Connection")
    
17. oConn.Open connectstr
    
18. 
    
19. qry = "SELECT * FROM " & tablename
    
20. 
    
21. Set oRS = oConn.Execute(qry)
    
22. 
    
23. if not oRS.EOF then
    
24. while not oRS.EOF
    
25. response.write ucase(fieldname) & ": " & oRs.Fields(fieldname) & "
    
26. "
    
27. oRS.movenext
    
28. wend
    
29. oRS.close
    
30. end if
    
31. 
    
32. Set oRs = nothing
    
33. Set oConn = nothing
    
34. 
    
35. %>

复制代码

jearol

谢谢老大
先试试，呵呵