ÏÖÔÚÓиöÎÊÌâ¡£¡£
1.oracle 10gĬÈÏÁ¬½ÓʹÓõÄioc.dllµÄJDBCÁ¬½Ó°É¡££¨ÎÒÊÇÕâÑùÈÏΪµÄ£¬²»ÖªµÀ¶Ô²»¶Ô¡£¡££©
2.µ«ÎÒÏÖÔÚ²»ÏëÓÃIOC.DLLµÄ·½Ê½Á¬½Ó¡£ÎÒÒª»»³ÉODBCµÄÁ´½Ó·½Ê½£¬ÇëÎÊÎÒÒªÔõô×ö¡£¡£
3.Èç¹ûÁ¬½Ó³É¹¦£¬ÎÒÒªÔÚoracle 10gÀïÃæÔõôÅжÏÊÇioc.dllÁ¬½Ó»¹ÊÇodbcÁ¬½ÓÄØ£¿
ÒÔÉϲ»ÊÇÓñà³ÌÓïÑÔÁ¬½Ó¿©¡£¡£¾ÍÊǿͻ§¶ËÓë·þÎñ¶ËÖ®¼äµÄÁ¬½Ó¡£¡£
ÄãÏÖÔÚµÄÁ¬½ÓÓï¾äÊÇ?
¿Í»§¶ËÓõÄÊÇsqlplus system/password@xxx
ioc.dll?
Ö¸µÄÊÇoci.dll£¿
ÒýÓà ioc.dll? Ö¸µÄÊÇoci.dll£¿ ¶Ô¶Ô¡£¡£¹þ¹þ¡£¡£¡£´ò´íÁË¡£
Â¥Ö÷×î½üºÃÏñÒ»Ö±ÔÚÎÊÀàËÆµÄÎÊÌâ¡£±¾È˸оõÒâÒå²»´ó£¬²»ÖªµÀÂ¥Ö÷ÊÇʲôÐèÇ󡣡£¡£
OciÊÇOracle Êý¾Ý¿âµ÷Óýӿڣ¬ÊÇÓÉOracleÌṩµÄÓÃÓÚ¿ª·¢Ç°¶ËÓ¦ÓóÌÐò¼°Öмä¼þµÄC/C++¿ª·¢Àà¿â¡£
OCI»¹ÊÇÆäËûOracle¿ª·¢½Ó¿ÚµÄµ×²ãʵÏÖ£¬¶øJDBCµÈÊÇÔÚOCIÉϲãµÄ·â×°¡£--×¢ÒâÇø±ð
Â¥Ö÷²Î¿¼ÏÂÃæµÄÁ´½Ó£¬»òÐíÊÇÄãÒªµÄ¶«Î÷¡£¡£¡£
http://www.xue163.com/html/20091212/2708285.html
ÎÒÏÖÔÚÐèÒª¸ãÇå³þÔõôÓÃODBCÈ¥Á¬½ÓÔÚ¿Í»§¶ËÁ¬½Óoralce¡£¡£¡£
¸Ð¾õÂ¥Ö÷ûÓиãÇå³þ×Ô¼ºµÄÐèÇó,¼¼ÊõÖ»ÊÇÊÖ¶Î,¿ÉÒÔʵÏÖÐèÇóµÄÊֶβ»ÎÊÊÇ·Ç
ÒýÓà ÎÒÏÖÔÚÐèÒª¸ãÇå³þÔõôÓÃODBCÈ¥Á¬½ÓÔÚ¿Í»§¶ËÁ¬½Óoralce¡£¡£¡£ºÇºÇ£¬ÍøÉÏÒ»´ó°ÑÕâÑùµÄÀý×Ó°¡£¡
Ò²¾ÍÊÇ˵¡£¡£¡£ÎÒÓÃsqlplusÊÇÎÞ·¨ÓÃodbcÁ¬½ÓµÄ£¿¡£¡£¡£
ÆäʵÎÒµÄÒâ˼ÊÇ£¬¾ÍÖ»ÓÃsqlplusºÍÅäÖÃODBCÊý¾ÝÔ´À´Á¬½Óserver¡£¡£¡£ÖÁÓÚÓÃÓïÑÔÀ´Á¬½Ó¡£¡£ÄǸöÍøÉÏÒ»´ó¶ÑÁË¡£¡£¡£¡£
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......