{"id":6,"date":"2004-10-22T12:57:27","date_gmt":"2004-10-22T04:57:27","guid":{"rendered":"http:\/\/192.168.0.1\/blog_4.4.2\/?p=6"},"modified":"2004-10-22T13:02:15","modified_gmt":"2004-10-22T05:02:15","slug":"vb6s-mysql","status":"publish","type":"post","link":"https:\/\/blog.worren.net\/?p=6","title":{"rendered":"VB6\u9023 MySQL"},"content":{"rendered":"<div class='drop-case'> <p> MySQL<-->MyODBC<-->ADO<-->Recordset<-->VB6<\/div>\n <p> \u6211\u60f3, \u5728 VB.NET \u88e1\u61c9\u8a72\u4e5f\u53ef\u4ee5, \u53ea\u662f VB.NET\u5167\u5efa\u662f\u7528 ADO.NET <br \/> \n\u53ef\u80fd connection string \u4e0d\u592a\u4e00\u6a23! ..\n <p> step 1.\n <p> \u5b89\u88ddMyODBC, \u6211\u662f\u5b89\u88dd MyODBC-standard-3.51.9-win.msi <br \/> \nsure, \u5230 http:\/\/www.mysql.com \u6293\n <p> \u5b89\u88dd\u597d\u5f8c, \u6211\u5b8c\u5168\u6c92\u6709\u505a\u8a2d\u5b9a! &#8230;\u53ea\u662f\u5728\u63a7\u5236\u53f0\u7684ODBC\u88e1\u770b\u5230\u591a\u4e00\u9805driver: <br \/> \nMySQL ODBC 3.51 Driver <br \/> \n <!--more--> \n <p> step 2.\n <p> \u5efa\u7acb connection <br \/> \n\u53ca\u900f\u904e ADO  \u628a\u8cc7\u6599\u6488\u9032 Recordset &#8230;\n<pre><code>Dim conn As New ADODB.Connection\r\nDim rs As New ADODB.Recordset\r\nDim rs_result As Recordset\r\n\r\nPrivate Sub Form_Load()\r\n\r\n   connstr = \\\"Driver={MySQL ODBC 3.51 Driver};server=localhost;\\\" &amp; _\r\n                \\\"UID=username;PWD=password;database=phpbb2;Option=4;\\\"\r\n   conn.Open connstr\r\n   rs.CursorLocation = adUseClient\r\n\r\nEnd Sub\r\n\r\nPrivate Sub Command1_Click()\r\n   Dim strSQL as String\r\n\r\n   strSQL=\\\"Select * from phpbb2_posts\\\"\r\n   rs.Open strSQL, conn, adOpenDynamic, adLockReadOnly\r\n   set rs_result = rs.clone\r\n   rs.close\r\n\r\nEnd Sub<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":" <p> MySQLMyODBCADORecordsetVB6 \u6211\u60f3, \u5728 VB.NET \u88e1\u61c9\u8a72\u4e5f\u53ef\u4ee5, \u53ea\u662f VB.NET\u5167\u5efa\u662f\u7528 ADO.NET \u53ef\u80fd connection string \u4e0d\u592a\u4e00\u6a23! .. step 1. \u5b89\u88ddMyODBC, \u6211\u662f\u5b89\u88dd MyODBC-standard-3.51.9-win.msi sure, \u5230 http:\/\/www.mysql.com \u6293 \u5b89\u88dd\u597d\u5f8c, \u6211\u5b8c\u5168\u6c92\u6709\u505a\u8a2d\u5b9a! &#8230;\u53ea\u662f\u5728\u63a7\u5236\u53f0\u7684ODBC\u88e1\u770b\u5230\u591a\u4e00\u9805driver: MySQL ODBC 3.51 Driver <\/p> \n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4,3],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.worren.net\/index.php?rest_route=\/wp\/v2\/posts\/6"}],"collection":[{"href":"https:\/\/blog.worren.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.worren.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.worren.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.worren.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6"}],"version-history":[{"count":0,"href":"https:\/\/blog.worren.net\/index.php?rest_route=\/wp\/v2\/posts\/6\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.worren.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.worren.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.worren.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}