mssqlÓëmysql»¥·ÃÎÊÌâ
ÏÖÔÚ×÷Á˸öϵͳ,Êý¾Ý¿âʹÓÃmysql,µ«ÊÇÐèÒª´ÓÁíÒ»¸öMSSQLÖлñµÃһЩ»ù´¡Êý¾Ý,Çë½Ì¸÷λ,ÎÒÄܲ»ÄÜͨ¹ýÒ»ÖÖ·½Ê½»ñµÃÏ໥µÄÊý¾Ý,лл!
MS SQL server µ¹ÊÇ¿ÉÒÔÔÚÕâ¼ÜWINODWS ·þÎñÆ÷ÉÏ°²×°MYSQLµÄODBCÇý¶¯£¬È»ºó½øÐзÃÎÊ¡£
mysql ·ÃÎÊSQL SERVERûÓа취¡£
ÓóÌÐò´¦Àí£¬±ÈÈçMySQLµÄÊý¾ÝǨÒƹ¤¾ß¾ÍÊÇÀûÓÃJDBCµÄ£¬¿ÉÒÔ½«Oracle/SQL SvrµÄÊý¾Ýµ¼ÈëMySQL
Ö»ÄÜÔÚMSSQLµÄÄÇ̨»úÆ÷ÉϲÙ×÷ÁË£¬´ÓMYSQLÀï¶ÁÊý¾Ý£¬»òÕß°ÑÊý¾Ýдµ½MYSQLÀMYSQL ·ÃÎÊMSSQLû°ì·¨¡£
ÇëÍƼöÒ»¿îODBCÁ¬½ÓÆ÷,ÎÒÏÖÔÚÓõÄÊÇmysql odbc 3.51 dirver ÄÜÔÚ¿ØÖÆÃæ°åÀィÁ¢Êý¾Ý¿âÁ¬½Ó.
Ò²ÄÜͨ¹ýpowerbuild·ÃÎÊÊý¾Ý¿â,µ«ÊÇÔÚMSSQLÀïÃæÌí¼Ó·þÎñÆ÷Á¬½Óʱ»¹ÊÇûÓÐMYSQLµÄODBCÇý¶¯Ñ¡Ïî
ÏÖÔÚ×÷Á˸öϵͳ,Êý¾Ý¿âʹÓÃmysql,µ«ÊÇÐèÒª´ÓÁíÒ»¸öMSSQLÖлñµÃһЩ»ù´¡Êý¾Ý
û¸ãÇå³þɶÍæÒâ½ÐÒ»¸öϵͳ£¬Èç¹ûÊÇÓõÄijÓÃÓïÑÔ×öµÄijÈí¼þÖ®ÀàµÄ¶«Î÷¡£¶ÁÁ½¸ö¿âÍêÈ«ÊÇûÓÐÎÊÌâµÄ¡£
Èç¹ûÊÇ×öÁËij¸öÎÒδ֪µÄϵͳ£¬ÄǾͲ»ºÃÒâ˼µÄ£¬ÎÒ¼ûʶ¶Ì....
Êý¾Ý¿â±¾Éíȥȥ±ðµÄ¿âÀï¶Á¶«Î÷Âð£¿ÄÇ»ù±¾ÉϾÍÊÇÊý¾ÝµÄͬ²½Ê²Ã´µÄ....
ºÜÎÞÓïÕâÑùµÄ±í´ïÄÜÁ¦¡£
ºÃµÄ,лл,ÎÒÔÙÊÔÒ»ÏÂ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕⶼװÁ赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆ̨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......