Çë½ÌjsÈçºÎ²Ù×÷oracleÊý¾Ý¿â - Web ¿ª·¢ / JavaScript
ÈçºÎÓÃjsÁ¬½ÓoracleÊý¾Ý¿â£¬´´½¨±í£¬Ìí¼ÓÊý¾ÝµÈ²Ù×÷£¬¾Ù¼¸¸ö¼òµ¥µÄjs´úÂëÀý×Ó¿´¿´£¿
JSÊǿͻ§¶ËµÄ¶«Î÷£¬Êý¾Ý¿âÊÇÔÚ·þÎñÆ÷¶ËµÄ¶«Î÷¡£
Èç¹ûÄãÏëÒªÓÃJS²Ù×÷Êý¾Ý¿â£¬ÄÇô£¬ÄãÐèÒªÔ¤ÏÈÔÚ·þÎñÆ÷¶Ë±àдºǫ́³ÌÐò£¬Õâ¸ö³ÌÐò¿ÉÄÜÊÇasp, php, javaµÈ£¬µ«²»ÊÇJS¡£È»ºóÒ³ÃæÀïͨ¹ýajax»òÕßÖ±½Óͨ¹ýÒ³ÃæµÄÌø×ª£¬È¥µ÷Óúǫ́³ÌÐòÀ´²Ù×÷Êý¾Ý¿â
JScript code:
var con = new ActiveXObject("ADODB.Connection");
con.open("Provider=OraOLEDB.Oracle;Source='';User ID='';Password='';PLSQLRset=1");
ÕâÑù¾Í¿ÉÒÔÁ¬½ÓÊý¾Ý¿â¶ÁÈ¡Êý¾ÝÁË
JSµÄÔ´´úÂëÒ»°ã±ðÈ˲鿴ԴÎļþ¾ÍÄÜ¿´µ½ÁË¡¡
Ö±½ÓÓÃÀ´²Ù×÷£¬»áºÜ±¯ÇéµÄ
¶øÇÒActiveXObjectµÄ¼æÈÝÐÔ¡Ò²»áÏ൱µÄ±¾ß
var con = new ActiveXObject("ADODB.Connection");
con.open("Provider=OraOLEDB.Oracle;Source='';User ID='';Password='';PLSQLRset=1");
wangfuxiang ÄãÓÃÕâÑùµÄajaxÁ¬½ÓÊý¾Ý¿âÂð£¿
ÔÚʵ¼ÊÏîÄ¿ÖÐÖ¸¶¨²»ÄÜÓÃjsÁ¬½ÓÊý¾Ý¿âÁË£¬°²È«ÐÔÎÊÌâ°¡£¡µ«ÊÇÕâÖÖ·½·¨È·ÊµÊÇ¿ÉÒÔÁ¬½ÓÊý¾Ý¿âµÄ¡£
4Â¥µÄÈç¹û¸ÒÐËȤ¿ÉÒÔ³¢ÊÔÏ£¬ËÙ¶ÈÒ²Âù¿ìµÄ¡£
aspµÄ»° Óà jscriptд·þÎñÆ÷ Á¬ oracle°¡
Ò»°ã²»ÓÃÕâ¶«Î÷²Ù×÷Êý¾Ý¿âµÄ°É¡£¡£
ÓÃ ActiveXObject
µÄ»°»ðºü ²»¼æÈÝ
Ïà¹ØÎÊ´ð£º
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿ ......