ÇëÅóÓÑÃÇÌṩÏÂdominoÁ¬½ÓmysqlÊý¾Ý¿âµÄ×ÊÁÏ
лл
Ö±½ÓÓÃadoÒ²¿ÉÒÔ
Dim conn As Variant
Dim rstt As Variant
Dim ConnAdmin As String
Set conn = CreateObject("ADODB.Connection")
ConnAdmin = "driver={MySQL ODBC 3.51 Driver};server=db1.database.com;database=test;uid=sa;pwd=test"
conn.open ConnAdmin
Set rstt=createobject("adodb.recordset")
SQL = {SELECT * from test }
rstt.open SQL,conn,1,3
'ÕâÀï¿ÉÒÔ¶Ôrstt½øÐÐÔö¼Ó¼Ç¼£¬²éѯµÄ²Ù×÷£¬¾ßÌåµÄ´úÂëÍøÉ϶¼ÓÐ
rstt.close
¸ù¾ÝÂ¥ÉϵĴúÂ룬²åÈëÊý¾Ý³É¹¦ÁË£¬µ«ÊÇÍùmysql²åÈëÖÐÎÄÄÚÈÝ£¬¾Í»á³öÏÖÂÒÂ룬Õâ¸öÎÊÌâÔõô½á¾Ö£¿
ps£ºÊDz»ÊÇÊý¾Ý¿â×Ö·û¼¯µÄÔÒò£¬domino×Ö·û¼¯ÊÇgb2312£¬mysql×Ö·û¼¯ÊÇgbk¡£ÓÉÓÚmysqlÊý¾Ý¿âÊÇÆäËû¿ª·¢ÉÌÌṩµÄ£¬ËùÒÔ²»ÄÜÐÞ¸ÄmysqlµÄ×Ö·û¼¯¡£
ÇëÎÊÓÐÆäËû±äͨµÄ·½·¨Ã»ÓУ¬¼´²»ÐÞ¸ÄÁ½±ßÊý¾Ý¿âµÄ×Ö·û¼¯£¬Êý¾Ý½á¹¹¡£¡£¡£
ÂÒÂëµÄÎÊÌ⻹ûÅöµ½¹ý£¬¶¥Ò»Ï¡£
ÎÒÕâ±ßҲûÓгöÏÖÂÒÂëµÄÇé¿ö£¬ÂÒÂëºÃÏñ¸úϵͳÓйذÉ
ÓÐÅöµ½¹ý¿Ë¡µÄϵͳ³öÏÖÂÒÂëµÄÇé¿ö
ÎÊÌâ½â¾öÁË£¬ÅäÖÃmyodbcÇý¶¯ÖеÄ×Ö·û¼¯½â¾öÎÊÌ⣬ллÒÔÉϸ÷λ¡£½áÌù
½üÈÕ£¬ÓÐÒ»¸öÏîÄ¿ÐèҪͨ¹ýOAϵͳ£¨Dominoƽ̨£©ÏòÒ»¸öMySQLÓ¦ÓòåÈë¼Ç¼£¬ÒòΪƽ̨ÊÇwindowsƽ̨£¬ËùÒÔ²ÉÓÃÁËODBCÁ¬½Ó·½Ê½£¬ÔÚOA·þÎñÆ÷Éϰ²×°ÁËMyODBC-3.51.11-1Çý¶¯£¬ÅäÖÃÁËODBCÇý¶¯Êý¾ÝÔ´Ö®ºó£¬²åÈë¼Ç¼³É¹¦£¬µ«²»ÂÛÊDzåÈëÖÐÎÄÄÚÈÝ£¬»¹ÊÇ´ÓMySQLÖжÁÈ¡ÖÐÎÄÄÚÈÝ£¬¶¼ÊÇÂÒÂ룬ÔÚÍøÉϲéÔÄÁ˸÷ÖÖ×ÊÁÏ£¬³õ²½ÅжϿÉÄÜÊÇ×Ö·û¼¯µÄÔÒò£¬Domino²ÉÓõÄÊÇgb2312£¬MySQL²ÉÓõÄÊÇgbk£¬Á½ÖÖ²»Í¬×Ö·û¼¯µ¼ÖÂÖÐÎÄÂÒÂëÎÊÌâ
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽ ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......