note 46220 added to function.mssql-connect
| From: | mworku at securiant dot com | Date: | Sat, 02 Oct 2004 23:16:56 +0000 |
| Subject: | note 46220 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-77766@lists.php.net to get a copy of this message | ||
It looks like by default libphp5 ignores freetd's conf file if you
specify your SQL server's ip address within the mssql_connect() function.
If you need to utilize freetds.conf file for connection parameters use the putenv function as
follows
<?
putenv('FREETDSCONF='path to your freetds conf. file')
/*
SQL CODE
mssql_connect('MSSQL_2000, 'user' , 'pwd');
....
....
*/
?>
All connection parameters should now be read from the conf file. Also don't enable logging
unless you're debugging, performace will suffer.
/* freetds.conf
[MSSQL_2000]
host = 192.168.10.10
port = 1433
tds version = 8.0
; dump file = /etc/freetds/log/freetds.log
; dump file append = yes
; debug level = 99
*/
----
Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+46220
Delete -- http://master.php.net/manage/user-notes.php?action=delete+46220&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+46220&report=yes
Search -- http://master.php.net/manage/user-notes.php