C#ÔõÑùÁ¬½Ó¾ÖÓòÍøÖÐÁíÒ»¸ö¼ÆËã»úµÄACCESSÊý¾Ý¿â£¿Çó´úÂ룬˵Ã÷
ÔÚÁíÒ»¸ö¼ÆËã»úµÄ¡°¿ØÖÆÃæ°å¡±µÄ¡°ODBCÊý¾ÝÔ´¡±ÖÐÉèÖá°DSN¡±¡£
°ÑACCESSÍêÈ«¹²Ïí
"\\¼ÆËã»úÃû\¹²ÏíĿ¼Ãû\ÎļþÃû.MDB"
DATA SOURCE£½\\192.168.0.1\A.mdb
ÓÃremoting
ÒýÓÃ
ÔÚ´Ë°ì·¨ÖУ¬»¹ÐèҪŠ......
ÎÒÓжàÌõÊý¾Ý£¨ÖÁÉÙ20Ìõ£©£¬Òª´ÓSQLÊý¾Ý¿âÀïÃæ²é³ö£¨×Ö¶ÎA£¬×Ö¶ÎB£¬×Ö¶ÎC£©µ¼³ö£¬Ìí¼Óµ½ACCESSÊý¾Ý¿âÀïÃ棨×Ö¶Î1£¬×Ö¶Î2£¬×Ö¶Î3£©ÀïÃ棬ÎÒ¸ÃÈçºÎ²éѯ£¬²¢Ìí¼Ó£¬ÇëÖ¸½Ì£¡
´´½¨Ò»¸öµ½SQL SERVERµÄÁ´½Ó±í£¬È»ºó¾Í¿ÉÒÔÖ±½Ó¸´ÖÆÁË¡£
{{ ......
СµÜ³åACCESSÊý¾Ý¿âÏòoracleÊý¾Ý¿âµ¼ÈëÊý¾Ý,ÓõÄÊÇinsert into selectÓï¾ä.sqlÈçÏÂ:
INSERT INTO [ODBC;DSN=pjgsDNS;UID=pjuser;PWD=bssoft001;].[T001_PX_BM_XM] SELECT t2.*,45 as FDW_ID from T001_PX_BM_XM t2
T001_PX_BM_XM ±í½á¹¹ÔÚÁ½¸öÊý¾Ý¿âÖÐÊÇÒ»ÑùµÄ.
ÔÚ³ÌÐòÖÐÔËÐÐ stmt.executeUpdate(sql ......
ллָµ¼Ò»ÏÂ
http://topic.csdn.net/u/20071126/19/b876ec04-7ebe-46e1-bf78-c87387fbb4d1.html
http://dev.yesky.com/243/2230743.shtml
²Î¿¼
ÒѾµ½C++ÁË
ºÇºÇ
ÓÃÏֳɵÄÊý¾Ý¿â½Ó¿ÚAPI°É,accessÂðÓÃODBC
°ïÄ㶥
ÖªµÀaccessµÄ´æ´¢¸ñʽ ¾Í¿ÉÒÔÓô¿c¶Á ´ò²»Á˶Á2½øÖÆÂï¡£¡£ºÇºÇ
»¹ÊDz»Ì«¶®¡£¡£ ......
ÇëÎÊ
ÎÒʹÓÃ_accessº¯ÊýÈ¥ÅжÏÎļþÊÇ·ñ´æÔÚ
ͬһ¸öÓ¦ÓóÌÐòÔÚһ̨»úÆ÷ÉÏÔËÐÐʧ°Ü¶þÁíһ̨»úÆ÷ÉÏÈ´Êdzɹ¦µÄ
ËùÅжϵÄÎļþÊÇ´æÔÚ´ÅÅÌÉϵÄ
ÇëÎÊÕâÊÇʲô»ØÊ£¿
ÈçºÎʹÓã¿£¿if (0 == access(filename.c_str(), 0) ){}
......
ÎÒÊÖ¶¯Ìí¼Ó»ùÓÚCRecordSetÀàµÄÅÉÉúÀàCODBCDemoSetÀà,ÊÇÀûÓÃclass wizardÌí¼ÓµÄ¡£²¢ÇÒ¶¨ÒåÁËÒ»¸öÈ«¾Ö±äÁ¿CODBSDemoSet*m_pCommon.µ«ÊÇÎÒ³ÌÐò²»ÄÜÔËÐС£ÎÒ¸ú×ÙÁËһϣ¬µ½ÁËm_pCommon->Isopen£¨£©´¦·¢Éú´íÎ󣬣ºunhandled exception in odbc.exe access violation!ÎÒ²éÁ˲é˵ÊÇÄÚ´æ´íÎ󡣺ÃÏñÊÇm_pCommonûÓгõʼ»¯£¬Ö ......