SchoolZone
ȸ¿ø°¡ÀÔ | | ȸ¿øÇýÅÃ
[¼³Ä¡/¼³Á¤] FreeTDS - PHP¿¡¼­ MS-SQL¿¡ Á¢±ÙÇϱâ
±Û¾´ÀÌ ¿À»ç¹«¿¤ ³¯ Â¥ 06-05-05 10:19 Á¶ ȸ 5668
1. Install MySQL client

# cd /usr/local/src
# wget http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.21.tar.gz/from/http://mysql.byungsoo.net/
# tar xvpfz mysql-5.0.21.tar.gz
# cd mysql-5.0.21
# ./configure --with-pthread --enable-thread-safe-client --without-debug --without-docs --without-bench \
--enable-assembler --with-charset=euckr --without-server
# make
# make install


2. Install Apache

# cd /usr/local/src
# wget http://mirror.apache.or.kr/httpd/httpd-2.2.2.tar.bz2
# tar xvpfj httpd-2.2.2.tar.bz2
# cd cd httpd-2.2.2
# ./configure --enable-so
# make
# make install


3. Install FreeTDS

# cd /usr/local/src
# wget http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz
# tar xvpfz freetds-stable.tgz
# cd freetds-0.63
# ./configure --prefix=/usr/local/freetds --with-tdsver=8.0 --disable-odbc --disable-debug --enable-msdblib
# make
# make install


4. Install PHP

# cd /usr/local/src
# wget http://kr.php.net/get/php-5.1.3.tar.bz2/from/this/mirror
# tar xvpfj php-5.1.3.tar.bz2
# cd php-5.1.3
# ./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql \
--with-mysqli=/usr/local/bin/mysql_config --enable-track-vars --enable-trans-sid --enable-ftp \
--disable-debug
# make
# make install
# cp php.ini-dist /usr/local/lib/php.ini


5. Install MS-SQL module

# cd /usr/local/src/php-5.1.3/ext/mssql
# phpize
# ./configure --with-mssql=/usr/local/freetds
# make
# make install
# vi /usr/local/lib/php.ini

    extension_dir = "/usr/local/lib/php/extensions/no-debug-non-zts-20050922/"
    extension=mssql.so
°úÀÏ¢â 06-05-06 00:35
FreeTDS´Â óÀ½ µé¾îº¸´Â°Å³×¿ä.
»õ·Î ³ª¿Â°Ç°¡¿ä..? :)
ÇÏ´Ãó·³ 06-05-06 01:32
³ª¿ÂÁö ²Ï³ª µÇ¾ú½À´Ï´Ù..
ÆÁ¾ØÅ×Å©¿¡µµ ¿¹Àü¿¡ ¿Ã¶ó¿Ô¾ú½À´Ï´Ù..

Àúµµ ÀÌ°É °¡Áö°í Sybase ¶û MSSQL À» ¿¬µ¿ÇÒ¼ö ÀÖ½À´Ï´Ù..
¹¹ ´ë·® µ¥ÀÌÅͰ¡ ¾Æ´Ï¸é ±×·°Àú·° Àß µ¹¾Æ°¡´Â °Í°°´õ±º¿ä.. ^^
±¤»ç¶û 06-05-08 11:13
ÇöÀç Linux+APACHE2+PHP5.1.3+MSSQL2000 ¿¬µ¿Çؼ­ ÀÛ¾÷ÁßÀε¥
FreeTDS0.63¿¡ ¹®Á¦ÀÎÁö ÀúÀÇ ¼­¹ö Ç÷¿Æû»óÀÇ ¹®Á¦ÀÎÁö ¸ð¸£Áö¸¸
SQLTEXTŸÀÔÀÌ¿ë½Ã¿¡ FreeTDSÇÁ·Î¼¼½º°¡ Á×¾î¹ö¸®´Â ¹®Á¦°¡ Àֳ׿ä..
FreeTDSÀÇ ¹®Á¦ÀÎÁö ¹ºÁö´Â È®ÀξȵÆÁö¸¸.. °³¹ß¹öÁ¯ÀÎ
FreeTDS0.65¿¡¼­´Â SQLTEXT¹®Á¦°¡ ¾ø½À´Ï´Ù..
Çåµ¥.. 0.63¿¡¼­ ÀߵǴø ÇÁ·Î½ÃÁ® ¸®´ø°ª ¹Þ´Â°ÍÀÌ 0.64³ª 0.65¿¡¼­´Â ¾ÈµÇ´õ±º¿ä..
±×·¡¼­ 0.65¿¡¼­ return´ë½Å select ·¹ÄÚµå¼ÂÀ» ÀÌ¿ëÇØ¼­ ¹Þ°í Àֳ׿ä..
Âü°íÇϼ¼¿ä~
Ȥ½Ã 0.63¿¡¼­ SQLTEXTÀÌ»óÀÌ ¾øÀ¸½ÅºÐ ÀÖÀ½ »ç¿ëȯ°æ°ú ÄÄÆÄÀϿɼÇÁ» ÁöµµÇØÁÖ¼¼¿ä~
§ÀÌ 06-05-08 21:03
Sybase´Â 9.0ºÎÅÍ ¿¬°á°¡´ÉÇÕ´Ï´Ù.;;
»ðÁúÀÇ ÈçÀû-_-
JustDoItNow 06-06-05 11:38
¸®´ª½º + PHP¿¡¼­...MS-SQL2KÀ¸·Î ¿¬°á½Ã,
mssql_connect("IP", "¾ÆÀ̵ð", "¾ÏÈ£")·Î ¿¬°áÀÌ Á׾ ¾ÈµÇ´Â °æ¿ì
mssql_connect("IP:PORT", "¾ÆÀ̵ð", "¾ÏÈ£")·Î ÇØº¸½Ã¸é µË´Ï´Ù.
±âº» Æ÷Æ®´Â 1433¹øÀÓ

¿¹Á¦1) mssql_connect("123.123.123.123/1433") (X) ½½·¡½¬µµ ¾ÈµÊ
¿¹Áµ2) mssql_connect("123.123.123.123,1433") (X) ÄÞ¸¶µµ ¾ÈµÊ
¿¹Á¦3) mssql_connect("123.123.123.123:1433") (O) ÄÝ·Ð OK


ÀÌÆ²µ¿¾ÈÀÇ »ðÁúÀÇ ÈçÀû -_-; 2

À̰г²±æ·Á°í ȸ¿ø°¡ÀÔÇÔ ¤Ð.¤Ð
xµô¸¶ 06-06-13 11:50
¼ö°í Çϼ̽À´Ï´Ù. ÁÁÀº Á¤º¸¿¡ °¨»çµå¸®¸ç.. ^^

°í¿î ÇÏ·ç º¸³»¼¼¿ä
xµô¸¶ 06-06-13 13:45
¿À´Ã ¼³Ä¡ ÇØº»ÈÄ mssql À» php ¼³Ä¡ ȯ°æ¼³Á¤½Ã  --with-mssql=/usr/local/freetds ÀÌ¿É¼Ç Ãß°¡ ÇØ¼­ ÇϽøé mssql ¸ðµâ º°µµ ¼³Á¤ÀÌ ÇÊ¿ä ¾øÀ»°Í °°½À´Ï´Ù. [Âü°í php 5.1.4]

°í¿î ÇÏ·ç º¸³»¼¼¿ä
xµô¸¶ 06-06-13 14:11
mssql
MSSQL Support                                      enabled
Active Persistent Links                              0 
Active Links                                            0 
Library version                                        FreeTDS 

Directive                            Local Value                Master Value
mssql.allow_persistent          On                            On
mssql.batchsize                    0                              0
mssql.charset                      no value                    no value
mssql.compatability_mode      Off                          Off
mssql.connect_timeout        5                              5
mssql.datetimeconvert          On                            On
mssql.max_links                    Unlimited                  Unlimited
mssql.max_persistent            Unlimited                  Unlimited
mssql.max_procs                  Unlimited                  Unlimited
mssql.min_error_severity      10                            10
mssql.min_message_severity  10                            10
mssql.secure_connection      Off                          Off
mssql.textlimit                      Server default            Server default
mssql.textsize                      Server default            Server default
mssql.timeout                      60                          60

¼³Ä¡ÈÄ phpinfo() ¿¡¼­ È®ÀÎµÈ Á¤º¸ ÀÔ´Ï´Ù.  (mssql ¼³Á¤ ÇÏ´Â°Ç Ã³À½À̶ó ^^)

¾ÆÁ÷ mssql ¼­¹ö·Î »ç¿ëÀüÀÔ´Ï´Ù. ÀÌÁ¦ ºÎÅͰ¡ ¹®Á¨°¡ ^^

¾Ïư Àß µÇ³×¿ä


°í¿î ÇÏ·ç º¸³»¼¼¿ä
°Ô½Ã¹° 11,975°Ç
¹øÈ£ ºÐ·ù Á¦¸ñ ±Û¾´ÀÌ ³¯Â¥ Á¶È¸
11,975 ¹ö±× Ç¢´çÇÑ Firefox ¹ö±× [9] ½Ã¿ìã¿éë 10-07-29 341
11,974 ÇÔ¼ö [PHP] Æ®À§ÅÍ(?) ó·³ ³¯Â¥µ¥ÀÌÅ͸¦ °£¼ÒÇÏ°Ô Ãâ·Â [8] ¿ì»çÀκ¼Æ® 10-07-24 639
11,973 ÇÔ¼ö [PHP5] CF Menu 0.1.1 ±×³× 10-07-22 617
11,972 ½ºÅ©¸³Æ® jquery ellipsys ÀÔ´Ï´Ù. [6] ¸Û±× 10-07-19 759
11,971 ½ºÅ©¸³Æ® [jquery] .live ¿¡¼­ change À̺¥Æ® »ç¿ëÇϱâ(²Ä¼öÀÓ) [5] Äðº¸À̱³¿ø 10-07-15 578
11,970 DBMS MSSQL > MySQL µ¥ÀÌÅÍ ÀÌÀü °ü·Ã 1¿ø Tip [1] AJ½ÄÀÌ´Ô 10-07-13 626
11,969 ½ºÅ©¸³Æ® DatePicker ³¯Â¥ Á¾·áÀÏ Ã¼Å©. [3] Äðº¸À̱³¿ø 10-07-12 503
11,968 Á¤º¸ ÇÑ±Û HWP ¹®¼­ÆÄÀÏ ¾ç½Ä °ø°³ [8] »ç¾ÇÇѹڴ븮 10-07-12 822
11,967 HTML CSS(CLASS)¸¦ »ç¿ëÇÑ SHOW , HIDE ¹æ¹ý [12] °ø´ë¿©ÀÚ 10-07-10 694
11,966 ½ºÅ©¸³Æ® [jQuery] datePicker ------ °¡´ÉÇÑ Á¾·áÀÏ Ã¼Å©[º¸¿Ï¼öÁ¤] [6] Äðº¸À̱³¿ø 10-07-09 471
11,965 Á¤º¸ ´ÙÀ½ ½Ç½Ã°£À̽´ °Ë»ö¾î XML Ãâ·ÂÇϱâ [5] Äí·¹ÀÌÁö½ß 10-07-08 707
11,964 ½ºÅ©¸³Æ® jquery ÀÚµ¿¿Ï¼º autocomplete ±â´É ½±°Ô Àû¿ëÇϱâ [6] Á¦ºÎµµ¼Ò³â 10-07-08 847
11,963 ¾Ë°í¸®Áò SOAP [4] ³ª´®À̶õ 10-07-07 682
11,962 ±âŸ ³×ÀÌÆ®¿Â ÇÁ·Ï½Ã ¼­¹ö ¼³Á¤Çϱâ (¹«·á) [2] °¡ºñ¸¸¼¼ 10-07-05 1007
11,961 ±âŸ ÇÁ·Ï½Ã ¼­¹ö (High anonymous) »ç¿ëÀÚ Ã¼Å© Çϱâ. [8] KzMJN 10-06-25 1040
11,960 ¼³Ä¡/¼³Á¤ [asp] ¾÷·Îµå ÄÄÆ÷³ÍÆ® (nfupload+freeaspupload) º½µ¹¤Ô 10-06-23 899
11,959 ÇÔ¼ö ½±°Ô ½±°Ô Xpath ÇÔ¼ö ´ÙÇÁ¸° 10-06-19 1127
11,958 ½ºÅ©¸³Æ® ajax(jquery) ¹«ÇÑ ½ºÅ©·Ñ ½ºÅ©·Ñ ³¡¿¡ °¡¸é ´ÙÀ½ µ¥ÀÌÅÍ ·Îµå [6] daniselseo 10-06-14 1829
11,957 ÇÔ¼ö °Ô½Ã¹°ÀÌ »è.Á¦. µÇ¾ú½À´Ï´Ù. [2] BiHon 10-06-09 1146
11,956 ÇÔ¼ö °Ô½Ã¹°ÀÌ »è.Á¦. µÇ¾ú½À´Ï´Ù. [13] BiHon 10-06-07 1617
ȸ»ç¼Ò°³ »çÀÌÆ®¸Ê ÀÌ¿ë¾à°ü °³ÀÎÁ¤º¸Ãë±Þ¹æÄ§ À̸ÞÀÏ ¹«´Ü¼öÁý °ÅºÎ ÀÎÀçä¿ë Á¦ÈÞ¹®ÀÇ ±¤°í¾È³»
(ÁÖ)ÇÇ¿¡ÀÌÄ¡ÇǽºÄð´åÄÄ »ç¾÷¹øÈ£ 119-86-25309 ÅëÆÇ 2010-¼­¿ï±Ýõ-0082È£ Á÷¾÷Á¤º¸ ¼­¿ï°ü¾Ç Á¦2010-03È£
¼­¿ï½Ã ±Ýõ±¸ °¡»êµ¿ 371-50 ¿¡À̽ºÇÏÀ̾صå3Â÷ 9Ãþ ´ëÇ¥ ÀÓ¼ºÁø °³ÀÎÁ¤º¸º¸È£Á¤Ã¥ ¹× ´ã´ç ÇϹÌÇâ
ÀüÈ­ 02-2627-6637 ÆÑ½º 02-2624-1371 E-mail member@phpschool.com
Copyright PHPSCHOOL.com All rights reserved.