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

WIN7ÏÂORACLE°²×°Á¬½ÓµÄÎÊÌâ

ÎÒÓÐÒ»¸öVBA³ÌÐò£¬ÔÚXPÏÂÔËÐÐÕý³££¬µ«ÔÚWIN7ÔËÐÐÊý¾Ý¿âÁ¬½ÓÄǶδúÂë¾Í±¨´í£º"TNS:ÎÞ·¨½âÎöÖ¸¶¨µÄÁ¬½Ó±êʶ·û"
ÎÊÌâÀ´ÁË£º
1 ÎÒÔÚWIN7ϵͳÀïnet configuration assistantµã»÷ÁËû·´Ó¦
2 ¸ù¾ÝÒÔÍù¾­Ñ飬ÎÒÅжÏtnsnames.oraÎļþÓÐÎÊÌ⣬µ«¼ì²éÏÂÀ´Ó¦¸ÃÕýÈ·µÄ
3 ÎÒÓÃPL/SQL¹¤¾ßÈ¥Á¬Êý¾Ý¿â£¬È´ÊÇÄÜÕý³£Á¬½ÓÉϵÄ
4 ´úÂëÈçÏ£ºSet Osess = CreateObject("OracleInProcServer.XOrasession")
  Set Odb = Osess.OpenDatabase("JVRPT", "RPTOWN/RPTOWN0", 0&)

ÄÄλ¸ßÊÖ°ïæ½â¾öÏ ÒѾ­À§ÈÅÁËÎÒ2ÌìÁË Ð»Ð»~


¼àÌýÓÐÎÊÌâ.

ÔÚÃüÁîÐÐÀïÔËÐÐnetca¿´¿´¿ÉÐÐ..




ÔËÐÐÁËÖ®ºóÏÔʾÈçÏ£º
java.io.FileNotFoundException: F:\oracle\pr
ca\netca-1002228ÉÏÎç5840.log (¾Ü¾ø·ÃÎÊ¡£)
  at java.io.FileOutputStream.open(Na
  at java.io.FileOutputStream.<init>(
  at java.io.FileOutputStream.<init>(
  at oracle.net.ca.NetCA.main(Unknown

Oracle Net Services ÅäÖÃʧ°Ü¡£Í˳ö´úÂëÊÇ-1



Êý¾Ý¿â°²×°Ã»ÓÐÎÊÌâ°É£¿ 





------------------------------------------------------------------------------ 
Blog£º http://blog.csdn.net/tianlesoftware 
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net 
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx 
Q Q Ⱥ£º62697716

PL/SQL¹¤¾ßÁ¬½ÓûÎÊÌâ..¾Í¿Ï¶


Ïà¹ØÎÊ´ð£º

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

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

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

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

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

oracle´¥·¢Æ÷²åÈëÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷
µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿
È磺 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ