mysql proxyÔÚwindowsϵÄʹÓÃÖ¸µ¼£¬ÇëÊìϤµÄÈ˸ø¸öÓ¦ÓÃÖ¸µ¼Ö®ÀàµÄÎÄÕ¡£Ð»Ð»¡£
ûÈËÖ¨ÉùÂð£¿
´ó¼ÒÓÐÈËÀ´Ëµ¾ä»°Âð£¿
ÎÒͨ¹ýÐÞ¸ÄÓ¦ÓóÌÐòµÄ·½Ê½ÊµÏÖÁ˶Áд·ÖÀë¡£µ«ÕâÑù×ӵϰÔÚ¶¯Ì¬µÄ¸ºÔؾùºâ·½Ãæ´¦ÀíÆðÀ´¾ÍÂé·³ÁË¡£
ÒòΪÁ¬½ÓÊÇÔÚϵͳÆô¶¯µÄʱºò¾Í½¨Á¢µÄ£¬Ò»Ö±Î¬³ÖÕâÈô¸É¸öÁ¬½Ó£¬Èôij´Ó·þÎñÆ÷³öÏÖ¹ÊÕÏ£¬ÒªÏë ......
declare @a int
select @a=id from tab2
insert into tab2 values(24,'a',@a)
print @a
select * from tab2;
±ÈÈçÀàËÆÉÏÃæµÄÓï¾ä£¬ÔÚmssqlÖоͿÉÒÔ£¬
²éÁËmysqlÊֲᣬÓÐÁ½¸öµØ·½Ò»¸ö˵ÔÚ´æ´¢¹ý³ÌÖУ¬ÁíÒ»¸öºÃÏñ˵±ØÐë°üº¬ÔÚbegin£¬end¡£¡£
ÄÇômysql¾ÍûÓÐÉúÃü±äÁ¿µÄ·½·¨À´Ã´£¿
MySQL¹Ù·½Î ......
ÎÒÓõÄibatisnet°æ±¾·Ö±ðÊÇ£¨dataaccess1.9.2,datamapper1.6.2£©,Á¬½Ómysqlʱ±¨´í£ºUnable to open connection to "MySQL, ByteFx provider V0.7.6.15073".
δ´¦Àí IBatisNet.DataMapper.Exceptions.DataMapperException
Message="Unable to open connection to \"MySQL, ByteFx prov ......
¸÷λºÃ£¬ÎÒ½«Áíһ̨µçÄÔÉϵÄMySQLÊý¾Ý¿âµÄÒ»¸ö±í¸´Öƺ󵽱¾µØ»úÉÏMySQLÊý¾Ý¿âÏàӦĿ¼(\dataĿ¼Ï£©£¬µ«ÊÇÔÚmysqlÃüÁîÌáʾ·ûÏÂÓÃshow tablesÃüÁî¿ÉÒÔÏÖʾ´æÔÚµ±Ç°±í£¬µ«ÊÇÓÃdescibe »òselect ÃüÁîʱȴ³öÏÖÎÞ·¨¶ÁÈ¡µÄÎÊÌâ,ϵͳÌáʾ¡°²»´æÔÚÕâ¸ö±í¡±µÄ´íÎó£»²»ÖªµÀÊDz»ÊDZ¾µØ»úÉÏÏàÓ¦Êý¾Ý¿âÉÏdb.optµÄÔÒò£¬ÏëÇë¸÷λ¸ßÊÖ½â¾ö ......
text ÒѰó¶¨adodc1
ÎҵĴúÂëÈçÏÂ
Private Sub Cmdadd_Click()
'Adodc1.Recordset.AddNew
'Adodc1.Recordset.Fields("wno") = Txtwno.Text
'Adodc1.Recordset.Fields("wname") = Txtwname.Text
'Adodc1.Recordset.Fields("storenum") = Txtstorenum.Text
''Adodc1.Recordset.Fields( ......
ÇóÓÃvbµÄodbcµÄ³ÌÐò¡£Ð»Ð»¡£
Á¬½ÓoracleµÄ£¬ÔÚÍøÉϲéÁËÏ£¬»ù±¾ÉÏûÓкõÄÀý×Ó¡£
²é²éconnectionstring¡£com
ÎÒÃǵÄÓ¦ÓóÌÐò±¨
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
ÊÖÀïûÓÐÔ´úÂëÎÞ·¨²é¿´£¬ËùÒÔ´òËã×Ô¼ºÅª¸övb£¬¿´¿´ÄÄÀïÎÊÌâ
Ó¦¸ÃÊÇodbcû½¨Á ......