note 82728 added to function.mssql-connect
| From: | dleons at gmail dot com | Date: | Wed, 23 Apr 2008 16:46:47 +0000 |
| Subject: | note 82728 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-138705@lists.php.net to get a copy of this message | ||
Hi
i'm an asp.net user for over 4 years. Now i'm tryin' php because i think it is quite
simple to understan. But I have a problem when using the mssql_connect function.
I've tried all the tips posted in this page, but I still can't connect to my MSSQL 2005
instance (placed in localhost).
I've made this changes:
update the ntwdblib.dll file with the latest version (200.80.194.0)
copy the ntwdblib.dll and php_mssql.dll file into the apache2.2/bin directory
copy the ntwdblib.dll into the c:/php directory
copy the ntwdblib.dll into the C:/WINDOWS/system32 directory
changed the authentication mode of sql server from windows authentication to mixed authentication
enable named pipes and tcp/ip protocol in sql server
My environment is configured as following:
-Apache 2.2.6
-PHP 5.2.5
-Windows XP SP2
-SQL Server listens on 1433 (default)
-Apache listens on 82 (localhost:82)
I didn't have any problem with connecting to sql server 2000/2005 with the odbc_connect()
function, but I've spent almost a week trying to connect with the mssql_connect function.
I beg you to help me
Thanks for reading
----
Server IP: 69.147.83.197
Probable Submitter: 190.41.4.78
----
Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php
Edit -- https://master.php.net/note/edit/82728
Del: integrated -- https://master.php.net/note/delete/82728/integrated
Del: useless -- https://master.php.net/note/delete/82728/useless
Del: bad code -- https://master.php.net/note/delete/82728/bad+code
Del: spam -- https://master.php.net/note/delete/82728/spam
Del: non-english -- https://master.php.net/note/delete/82728/non-english
Del: in docs -- https://master.php.net/note/delete/82728/in+docs
Del: other reasons-- https://master.php.net/note/delete/82728
Reject -- https://master.php.net/note/reject/82728
Search -- https://master.php.net/manage/user-notes.php