win 2000 server¿¡ perlÀ» ±ò°í dbi,dbd moduleÀ» ¼³Ä¡Çß±¸¿ä, À¥¼¹ö´Â iis 5.0À» ¾¹´Ï´Ù. win 2000¿¡ oracle nt client¿ë ¼³Ä¡Çß±¸, d:/orant/net80/admin/tnsnames.oraµµ ¼³Á¤Çß½À´Ï´Ù. ¼³Á¤ µÚ 2000ÀÇ sql-plus·Î db server¿¡ Àß Á¢¼ÓµË´Ï´Ù. db server´Â ¸®´ª½º6.2¿¡ oracle8À» ¾²±¸¿ä...
ÀÏ´Ü perlÀº µÇ±¸¿ä... db¿Í perlÀÌ ¿¬µ¿ÀÌ ¾È µË´Ï´Ù.
¼Ò½º´Â use cgi; use dbi; my $dbi = DBI->connect ('dbi:Oracle:CMB01;host=211.111.200.100','user','pass');
ȯ°æ º¯¼ö ¼³Á¤Àº $ENV{ORACLE_HOME} = '/oracle'; $ENV{TWO_TASK} = 'mb01'; $ENV{NLS_LANG}='American_America.KO16KSC5601'; $ENV{LANG}='ko'; $ENV{"PATH"}="$PATH:/oracle/bin"; $ENV{"LD_LIBRARY_PATH"}="$LD_LIBRARY_PATH:/oracle/lib"; $ENV{"ORACLE_SID"}="CMB01";
À§¿Í °°ÀÌ ÇØ ÁÖ¾ú´Â µ¥ ¿¬µ¿ÀÌ ¾È µË´Ï´Ù. ¾Æ¸¶µµ À§´Â À¥¼¹ö¿Í db ¼¹ö¸¦ °°Àº ¼¹ö¿¡ ¸®´ª½º·Î »ç¿ëÇÏ´Â °æ¿ì¿¡ À¯È¿ÇÑ °Í °°°í...À¥¼¹ö¿Í db server°¡ µû·ÎÀÎ °æ¿ì´Â ¾î¶»°Ô ÇؾßÇÒ Áö ¸ð¸£°Ú³×¿ä... ¶Ç win2000ÀÇ °æ¿ì´Â ȯ°æ º¯¼ö ¼³Á¤¹ýÀÌ ´Ù¸¥ °ÍÀÎÁö?...
Á¶¾ð ºÎŹÇÕ´Ï´Ù
|