ÇóMFCͨ¹ýODBCÁ¬½ÓMYSQLÀý×Ó
RT
ÒýÓà //³õʼ»¯dsn MyODBC::MyODBC(DataBaseType db_type,const char* driver,const char* dsn, const char* server,const char* db_name,const char* description,USHORT port) { m_erro = 0; m_row_count = 0; memset(m_sql_state,0,sizeof(m_sql_state)); memset(m_dsn,0,sizeof(m_dsn)); strncpy(m_dsn,dsn,sizeof(m_dsn) - 1); m_db_type = db_type; memset(m_db_name,0,sizeof(m_db_name)); strncpy(m_db_name,db_name,sizeof(m_db_name) - 1); memset(m_driver,0,sizeof(m_driver)); strncpy(m_driver,driver,sizeof(m_driver) - 1); memset(m_description,0,sizeof(m_description)); strncpy(m_description,description,sizeof(m_description) - 1); memset(m_ip,0,sizeof(m_ip)); strncpy(m_ip,server,sizeof(m_ip) - 1); char szPort[20]; memset(szPort,0,sizeof(szPort)); sprintf(szPort,"%d",port); m_port = port; char szAttributes[sizeof(m_dsn) + sizeof(m_ip) + sizeof(m_db_name) + sizeof(m_description) + 1]; memset(szAttributes,0,sizeof(szAttributes)); char* p = szAttributes; sprintf(szAttributes,"DSN=%s\nServer=%s\nDatabase=%s\nDescription=%s",m_dsn,m_ip,m_db_name,m_description); PR_DEBUG("this is port:%d\ndriver:%s\nAttributes:\n%s",port,driver,szAttributes); while( *p ) { if( *p ==
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶® ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ· ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar ºÃ¶«Î÷,ϸö¿´¿´ ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í: You can't specify target table 'a_table' for update in from clause ÍêÕûSQLÓï¾äÊÇ UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......