Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎÓÅ»¯½«±¾µØ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
================================================================
»Ø¸´£ºÊÇÌõ˼·£¬µ«ÓеãÒÉÎ


Ïà¹ØÎÊ´ð£º

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

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 - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

¹ØÓÚACCESSºÍMSSQLµÄÎÊÌâ - Web ¿ª·¢ / ASP

ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ