½ÃÀÛÆäÀÌÁö·Î Áñ°Üã±âÃß°¡
·Î±×ÀÎ
ȸ¿ø°¡ÀÔ l Ã⼮üũ l ¸¶ÀÌÆäÀÌÁö l CGIMALL
ÀÚ·á½Ç »çÀÌÆ®µî·Ï ·©Å·100 ÇÁ·Î±×·¥¸®ºä °ü¸®ÀÚÃßõÀÚ·á Ãʺ¸°¡À̵å
Ä¿¹Â´ÏƼ
Àüü ÆîÃ帱â
Äü¸Þ´º¸µÅ© jquery , CSS , PHP , Javascript , ¹«·áÆùÆ® , ASP
»ó¼¼°Ë»ö
Ȩ > Ä¿¹Â´ÏƼ > Áú¹®°ú´äº¯ »ó¼¼º¸±â
Ä¿¹Â´ÏƼ ±¸Àα¸Á÷
»çÀÌÆ®µî·Ï
Ŭ¶ó¿ìµåű×
Javascript
PHP
ASP
css
mysql
html
jquery
������
image
Mobile
API
slide
°Ô½ÃÆÇ
ÇöÀçÁ¢¼ÓÀÚ ¸í »õ·Î°íħ
°Ô½ÃÆÇŸÀÌƲ Áú¹®°ú´äº¯ / »ó¼¼º¸±â
Æ®À§ÅÍ·Î º¸³»±â
Ãßõ¼ö 85 | Á¶È¸¼ö 973 | µî·ÏÀÏ 2001-04-13 16:59:36

´Ð³×ÀÓ

sometimes

À̸ÞÀÏ

hm@mobbie.com

Á¦¸ñ

perl°ú oracle ¿¬µ¿...
³»¿ë

  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ÀÇ °æ¿ì´Â ȯ°æ º¯¼ö ¼³Á¤¹ýÀÌ ´Ù¸¥ °ÍÀÎÁö?...

Á¶¾ð ºÎŹÇÕ´Ï´Ù
Ãßõ½ºÅ©·¦¼Ò½ºº¸±â ¸ñ·Ï
ÀÌÀü°Ô½Ã±Û perl°ú oracle ¿¬µ¿... 2001-04-13 16:42:42
´ÙÀ½°Ô½Ã±Û C¾ð¾î·ÎµÈ CGI¿¡¼­ MSSQL¿¡ Á¢±ÙÇÏ´Â ¼Ò½ºÄÚµå? 2001-04-13 17:12:02