iis7 asp ado oracle ÂÒÂëÎÊÌâ
»·¾³£ºÊý¾Ý¿â oracle 64bit ϵͳ win2008 64bit IIS7 ÔÚasp ÍøÒ³ÖÐʹÓÃadoÁ¬½ÓÊý¾Ý¿â ODBCÓõÄÊÇMicrosft ODBC for oracle
Çé¿ö£ºÔÚÍøÒ³µÄ²éѯÓï¾äÖв»º¬ÖÐÎĵĿÉÒÔ£¬Ö»ÒªÓï¾äÖк¬ÓÐÖÐÎľͻ᷵»Ø´íÎó½á¹û¡£
Èç:select 'Ò»¶þÈý' from dual;ÕâÑùµÄÓï¾ä ·µ»Ø»ØÀ´¾ÍÊÇ£¿£¿£¿
»¹ÒªËµÃ÷µÄÊÇoracleµÄ×Ö·û¼¯ÊÇAMERICAN_AMERICA.US7ASCIIµÄ£¬ÄÇôÕâ¸öÄØ¾ÍÐèÒªÔÚ¿Í»§¶ËÒ²ÉèÖÃ×¢²á±íµÄnls_lang¼üֵΪAMERICAN_AMERICA.US7ASCII²¢ÇÒ»¹Ò»¶¨ÒªÓÃmicrosoft odbc for oracleÇý¶¯¡£·ñÔò¾ÍÂÒÂë¡£
¿ªÊ¼ÒÔΪÊÇ64λϵͳÏÂÇý¶¯µÄÊ£¬ÊÔÁ˰ëÌìûÓÐЧ¹û£¬ÒòÎªÍøÕ¾ÔÚ32λϵͳÏÂÍêȫûÓÐÎÊÌ⣬×îºóû°ì·¨¾Í°¤×Å¿´IIS7
µÄÉèÖÃ×îºó·¢ÏÖ“¿ÉÒÔн¨¸ö32λµÄÓ¦ÓóÌÐò³Ø
”ÕâÑù¾ÍÄܽâ¾öÎÊÌâÁË¡£¹þ¹þ£¬¼Ç¼ÏÂÀ´¡£
”32λµÄÓ¦ÓóÌÐò³Ø“ÒÔºó¿ÉÄÜ»¹»áÓõĵ½¡£
Ïà¹ØÎĵµ£º
Í£Ö¹Êý¾Ý¿â£¬Í£Ö¹·þÎñ¡£
È»ºóÔÚÔËÐÐÉý¼¶³ÌÐòʱ³öÏÖError:OUI-10133:Invalid stageing area. there
are no top level components
´íÎ󣬰ëÌì²»µÃÆä½â¡£ÖÕÓÚ·¢ÏÖÊÇÒòΪÉý¼¶°ü½âѹ²»ÍêÈ«Ôì³ÉµÄ¡£ÖØÐ¸´ÖÆÒ»·ÝÍêÕû½âѹ¹ýµÄ£¬Éý¼¶¡£OK. ......
¾°£ºÔÚwindows xp serverÉϰ²×°ÁËOracle 9.2.0.1£¬ÏÖʹÓÃp4547809_92080_WINNT.zip½«ÆäÉý¼¶µ½9.2.0.8°æ±¾£¬²¢´òÉÏ×î
Ðµİ²È«²¹¶¡April 2008°æ¡£
1.Éý¼¶oracle£¨administratorÓû§È¨ÏÞ£©£¨ÏÂÔØp4547809_92080_WINNT.zipÍøÖ·£º
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip£©
£¨1£©¡¢Ñ¹Ëõ°üÃû³ÆÎª p45478 ......
--ËøµÄ¸ÅÄî
Ëø³öÏÖÔÚÊý¾Ý¹²ÏíµÄ³¡ºÏ£¬ÓÃÀ´±£Ö¤Êý¾ÝµÄÒ»ÖÂÐÔ¡£µ±¶à¸ö»á»°Í¬Ê±ÐÞ¸ÄÒ»¸ö±íʱ£¬ÐèÒª¶ÔÊý¾Ý½øÐÐÏàÓ¦µÄËø¶¨¡£
-- ËøµÄģʽ£¬ÓÐÒÔϼ¸ÖÖģʽ
0£ºnone
1£ºnull ¿Õ
2£ºRow-S Ðй²Ïí(RS)£º¹²Ïí±íËø£¬sub share
3£ºRow-X ÐжÀÕ¼(RX)£ºÓÃÓÚÐеÄÐ޸ģ¬sub ex ......
¡¶oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/unixÉϵÄʵսÏê½â¡·¼¯ÖÐÌÖÂÛ35£ºÔÚAIX»·¾³ÏÂΪOracle¡¢sybase ʹÓÃÂãÉ豸 ÎÄÆ½ ÂãÉ豸ÊÂÒ»ÖÖÔÚUNIXϳ£ÓõÄÊý¾Ý¿âÊý¾Ý´æ´¢·½Ê½,ÔÚAIXÖÐÈç´Ë,ÔÚHP-UX\SCO UNIXµÈϵͳÖнÔÊÇÈç´Ë¡£Õâ¶ÎʱÆÚÒÔÀ´Ò»Ö±ÓÐͬ־ÃÇÓʼþѯÎÊÈçºÎʹÓÃÂãÉ豸¡£ÕâÀïÎÒ»ã×ÜһЩAIXÏÂÂãÉ豸µÄʹÓÃÎ ......
Oracle sqlplusÔ¶³ÌÁ¬½ÓÊý¾Ý¿â
sqlplus username/password@yunSID_192.168.1.5
¹«Ë¾Ê¹ÓÃlinux¿ª·¢»ú½øÐгÌÐò¿ª·¢Ê±£¬ÓÉÓÚ¿ª·¢ÓÃOracleÊý¾Ý¿âÊÇÓÉÈÕ·½Ìṩ£¬ËùÒÔ¾³£Ê¹ÓÃsqlplusÁ¬½Óµ½Ô¶³ÌÊý¾Ý¿âÉϽøÐпª·¢,ÀýÈ磺
sqlplus username/password@servicename
ÓÚÊÇÏ룬ÓÃÎÒµÄÁ½Ì¨µçÄÔË«»ú»¥ÁªÊÔÒ»ÊÔ£¬Ò²Íæ¸ö&ldq ......