Sybase 설치방법 점 구해주세엽...
2000 SQL서버에 제대루 접속을 할수 있게 부탁합니다.
초보 함 살려주세엽
-- 김수환 님이 쓰신 글:
>> 감사합니다.그런데 MSSQL2000 서버에서 사용을 해야 한다고 그러는데
>> 어떻게 해야 하는지..
>>
>> $dbconn = mssql_connect("semdb","sa","kdavin");
>> if(!$dbconn)
>> {
>> echo "ERRR ";
>> exit;
>> }
>> $db = mssql_select_db("semp");
>> 물론 아래에서 처럼 컴파일은 해봤습니다.
>>
>> MS SQL 2000 Version No. 라고 되어 있던데 2000은 다른것을 받아서
>> 컴파일을 해야 합니까??
>> 부탁 드립니다.
>>
>> -- jinuki 님이 쓰신 글:
>> >> www.php.net 에서 발췌한 내용인데요...
>> >> 도움이 되실듯 해서 다시 올립니다..
>> >>
>> >> elee@kinwai.net
>> >> 14-Apr-2002 10:29
>> >>
>> >> The belows procedures works on the following configuration: Mandrake linux
>> >> 8.2,MS Sql server 2000, windows 2000 server, PHP ver 4.12, apache
>> >> 1.3.24,Freetds 0.53.
>> >>
>> >> Configure Freetds
>> >> 1. Download Freetds 0.53 at www.freetds.org
>> >> 2. ./configure --prefix=/usr/local/freetds --with-tdsver=7.0
>> >> 3. make
>> >> 4. make install
>> >> 5. Edit /usr/local/freetds/etc/freetds.conf
>> >> 6. Add
>> >> [MyServer70] DSN for PHP
>> >> host = 10.23.52.114 MS SQL Server IP
>> >> port = 1433 MS SQL Default Port
>> >> tds version = 7.0 MS SQL 2000 Version No.
>> >> client charset = UTF-8 Charset Encoding, it can be omitted if you
>> >> don't want to disply in unicode
>> >>
>> >> Configure PHP 4.12
>> >> 1. Download PHP4 from www.php.net
>> >> 2. ./configure --with-sybase=/usr/local/freetds --with-apache=../{Apache
>> >> Path} --enable-track-vars
>> >> 3. copy all files in /usr/local/freetds/lib/ to /usr/lib
>> >> 4. make
>> >> 5. make install
>> >>
>> >> Configure Apache 1.3.24
>> >> 1. ./configure --activate-module=src/modules/php4/libphp4.a
>> >> 2. make
>> >> 3. make install
>> >> 4. cp php.ini-dist /usr/local/lib/php.ini
>> >> 5. Edit Your httpd.conf or srm.conf file and add;
>> >> AddType application/x-httpd-php .php
>> >> 6. /usr/local/apache/bin/apachectl start
>> >>
>> >> Feel free to email to us @ aikok@netfront.net or elee@kinwai.net
>> >> German Chu & Eagle Lee
>> >>
>> >>
>> >>
>> >> jd@keane.com
>> >> 24-Apr-2002 02:36
>> >>
>> >> Connecting to MSSQL 7 on UNIX/Apache/php4.1.2. I followed a bunch of
>> >> instructions below from folks using Linux and other configurations...so
>> >> give this a try, it may work.
>> >>
>> >> download freetds from www.freetds.org
>> >> configure arguments --with-prefix=/usr/local/freetds --with-tdsver=7.0
>> >>
>> >> edit freetds.conf in /usr/local/freetds/etc/freetds.conf
>> >> [MyServer70]
>> >> host = XX.XX.XX.XXX(your MSSQL IP)
>> >> port = 1433
>> >> tds version = 7.0
>> >> client charset = UTF-8
>> >>
>> >> reconfigure PHP using --with-sybase=/usr/local/freetds/ and all of your
>> >> normal args.
>> >>
>> >> restart apache and it works...well it did for me. Good luck
>> >>
>> >> jd
|