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¹¤¾ßÁ¬½ÓûÎÊÌâ..¾Í¿Ï¶
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......