<script>
var cpt_d="//192.168.8.163:1521/orclerp";
var john="taizhou_qy";
var doe="11hello!";
//Óà JavaScript д·þÎñÆ÷¶ËÁ¬½ÓÊý¾Ý¿âµÄ´úÂëʾÀý
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=OraOLEDB.Oracle;Data Source="+cpt_d+";User ID="+john+";Password="+doe+";PLSQLRset=1");
........
ÔËÐнá¹ûÏÔʾÕâÒ»¾ä´íÎó£¬
¡°Î´ÕÒµ½Ìṩ³ÌÐò£¬¸Ã³ÌÐò¿ÉÄÜδÕýÈ·°²×°¡±
Çë¸ßÊÖ°ïÖúÐ޸ġ£
ÎÒ¾ÍÊÇÏëÓÃjavascriptÁ¬½Óoracle£¬ÒÔǰÓÃvbscriptÁ¬½Ó£¬¶¼Õý³££¬µ«ÊÇ£¬javascript¿ÉʹÓõĺ¯ÊýºÜ¶à£¬Ïë¸ÄÓÃËüÀ´±à³Ì¡£
±¾»úµÄODBCÊý¾ÝÔ´ÄÜÕâÑùÁ¬½ÓoracleÂð
JavaScriptÁ¬½ÓÊý¾Ý¿â£¿²»ÖªÊÇÎÒÂäºóÁË»¹ÊÇ£¿
lzÍæÕâÖÖ£¿£¿
²»¶¥²»ÐÐ
¶¥Ìù»úq:525093551 ¶¥Ìû»ú
xyq1986
Ö»ÄÜЦЦÁË
¾ÍËãÄÜÁ¬ÉÏ£¬¿´ÁËjs´úÂ룬µØÇòÈ˶¼ÖªµÀÄãÊý¾Ý¿âµÄÓû§ÃÜÂëÁË
¶¥Â¥ÉÏ
Óýű¾Á¬Êý¾Ý¿â ûÓùý
¿¼µ½Õâ¸ö±êÌâÎÒ¾ÍÔÚÏ룺ΪʲôҪʹÓÃJavaScriptÁ¬½ÓÊý¾Ý¿â°¡£¿
Ϊʲô²»Ê¹ÓÃvbscriptÁ¬½Ó°¡£¿
ÄѵÀ¾ÍÒòΪÏÖÔÚJSºÜÁ÷ÐÐÂð£¿
ÄÜÁ¬ÉÏÒ²²»Ó㬲»°²È«
ÒýÓà <script> var cpt_d="//192.168.8.163:1521/orclerp"; var john="taizhou_qy"; var doe="11hello!"; //Óà JavaScript д·þÎñÆ÷¶ËÁ¬½ÓÊý¾Ý¿âµÄ´úÂëʾÀý var conn = new ActiveXObject("ADODB.Connection");
Ïà¹ØÎÊ´ð£º
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......