ÈçºÎÓÅ»¯½«±¾µØAccessÊý¾ÝдÈëµ½OracleÊý¾Ý¿âÖУ¿
ÏÖÓÐÒ»ÀÏC/Sϵͳ£¬¿Í»§¶ËÓÃVB×÷µÄ£¬²ÉÓÃAccessµÄ±¾µØÊý¾Ý¿â£¬µ«Êý¾ÝÔÚ±¾µØAccessÖд¦ÀíÍê³Éºó£¬×îÖÕÐèÒª½«AccessÊý¾ÝдÈëµ½OracleÖУ¬ÆäVB´úÂë´óÖÂÈçÏ£º //´ò¿ª±¾µØÊý¾Ý .... Set resLocal = RunSQLGetRS(CnnProjectDb, strSql) //´ò¿ª·þÎñÆ÷Êý¾Ý .... Set resServer = New ADODB.Recordset resServer.Open strSql, gOraSession //½«Êý¾Ý¸üÐÂÖÁOracleÖÐ While Not resLocal.EOF resServer.AddNew ... resLocal.MoveNext Wend resASMS.Update ÏÖÒòÓв¿·ÖÓû§ÔÚÍâµØ£¬Á¬½ÓOracle·þÎñÆ÷ËٶȺÜÂý£¬µ¼Ö½«Êý¾ÝдÈëÐ軨·Ñ½Ï³¤Ê±¼ä£¬ÇëÎÊÓÐʲôÓÅ»¯°ì·¨°¡£¿Çë¸ßÊÖÖ¸µã£¬¸Ð¼¤²»¾¡£¡£¡
ÍøÂçÔÒò£¬Ã»ÓÐʲôºÃÏëµÄ£¬ÂýÒ²µÃÕâÑùÁË£¬Â¥ÉϵIJ»Ì«ÏÖʵ£¬Èç¹ûÖ±½Ó´«ACESSµÄ»°£¬ÄܱÈORACLE¿ì£¿£¿Í¬ÑùµÄÍøÂç»·¾³¡£¡£¡£ ³ý·Ç½¨Á¢×Ô¼ºµÄרÏßVPN¡£¡£¡£¡£ ·過學習һϡ£¡£¡£¡£¡£¡£¡£ÒýÓÃ ÍøÂçÉÏÑÓ³ÙÔì³ÉµÄ£¬ÄǾͰþÀëÍøÂç²ãµÄÎÊÌ⣬½«accessÎļþ´«µ½±¾µØºóÔÙдoracle ¶¥Õâ¸ö ÍøÂçÉÏÑÓ³ÙÔì³ÉµÄ£¬ÄǾͰþÀëÍøÂç²ãµÄÎÊÌ⣬½«accessÎļþ´«µ½±¾µØºóÔÙдoracle ================================================================ »Ø¸´£ºÊÇÌõ˼·£¬µ«ÓеãÒÉÎ
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´... ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......