ÓÃVCÔõô¿ª·¢OracleµÄÓ¦ÓóÌÐò£¿²»ÓÃODBC
VC¿ª·¢SQL SERVERµÄÓ¦ÓóÌÐòÎÒÓÃADO
VC¿ª·¢MySQLµÄÓ¦ÓóÌÐòÎÒÓà MySQLµÄ¿ª·¢°ü£¬×°ÉÏÖ®ºó£¬ÔÚVCÀïÉèÖÃһϷ¾¶¾ÍÄÜ¿ª·¢ÁË
¾Í¸úVCÀïÉèÖÃSDK·¾¶Ò»Ñù
µ«ÊÇÎÒÏÖÔÚÒªÓÃVC¿ª·¢OracleµÄÓ¦ÓóÌÐò£¬ÔÚÍøÉÏËÑÁËËÑ£¬´ó²¿·Ö¶¼ËµÊÇÓÃODBC£¬
ÎÒʵÔÚ²»ÏëÓÃODBC£¬Îҷdz£ÏëÓÃÏñMySQL ÄÇÑùµÄ¿ª·¢°ü¡£
ËùÒÔÎÒµÄÎÊÌâ¾ÍÊÇOracleÓÐûÓÐÕâÑùµÄ¿ª·¢°ü£¿
¾ÍÊÇÌṩһ´ó¶ÑµÄ.hÎļþºÍ.libÎļþÓÃÓÚVCµÄ¿ª·¢£¿
ÌØ±ðÊÇOracle 10gµÄ£¬ÒÔΪÎÒµçÄÔÉÏ×°µÄ¾ÍÊÇOracle 10g
ÄãÊÇÒªÁ¬½ÓÊý¾Ý¿âÂð?? »¹ÊÇÒª¿ª·¢oracle Êý¾Ý¿â??? Èç¹ûÖ»ÊÇÏñodbcÕâÑùsdkÁ¬½øÈ¥£¬Äã¿ÉÒÔÈ¥ÏÂÔØÒ»¸ö½Ð×öÊÇ oracle client µÄ¶«Î÷£¬oracle ÍøÉÏÓ¦¸ÃÓС£
ÊÔÊÔoledbÊÔÊÔ°É
ÓÐ oci
Äã°Ù¶ÈһϾÍÖªµÀÁË Õâ¸öÊÇoracleÌṩµÄ½Ó¿Ú
²»¹ýÕâ¸ö½Ó¿Ú±È½Ï¸´ÔÓ ÍøÉÏÓкܶ࿪ԴÏîÄ¿ÌṩÁË·â×° ½¨ÒéÓ÷â×°ºóµÄ½Ó¿Ú£¬ÓÃÆðÀ´¼òµ¥
ÓÃOCI£¬»òOTL£¬Ç°ÌáÊǰ²×°ORACLE¿Í»§¶Ë
ͬÒâ¡£¡£¡£
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷
µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿
È磺 ......