|
감사합니다.그런데 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
|
