Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
================================================================
»Ø¸´£ºÊÇÌõ˼·£¬µ«ÓеãÒÉÎ


Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ