note 74783 added to function.mssql-connect
| From: | daslsack at hotmail dot com | Date: | Fri, 27 Apr 2007 10:51:51 +0000 |
| Subject: | note 74783 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-125912@lists.php.net to get a copy of this message | ||
I connected a WinXp prof ver 2002 sp2 box to a MsSQL server 2005.
Here is how (Assuming the MsSQL server is already running).
I installed the IIS via WinXP cd.
I downloaded and ran the file:
php-5.2.1-win32-installer.msi
(I chose IIS + ISAPI in the installation process)
I downloaded the files:
ntwdblib.dll (as mentioned in various posts above)
and
php_mssql.dll (found it in other PHP distributions)
I copied those files into the root PHP directory and modified the PHP.ini adding:
extension=php_mssql.php.
(note: The downloaded file php_mssql.dll may have to be put in the php\ext folder instead of the
root php folder depending on your extension path)
Reboot the IIS.
The php code for the connection is:
$this->sql_link = '0';
function connection() {
$this->sql_link = mssql_connect($this->"MyHost-NotIP", this->"MySelf",
$this->"SomePass");
mssql_select_db($this->"Databasename", $this->sql_link);
}
----
Server IP: 195.184.96.15
Probable Submitter: 194.239.133.38
----
Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php
Edit -- https://master.php.net/note/edit/74783
Del: integrated -- https://master.php.net/note/delete/74783/integrated
Del: useless -- https://master.php.net/note/delete/74783/useless
Del: bad code -- https://master.php.net/note/delete/74783/bad+code
Del: spam -- https://master.php.net/note/delete/74783/spam
Del: non-english -- https://master.php.net/note/delete/74783/non-english
Del: in docs -- https://master.php.net/note/delete/74783/in+docs
Del: other reasons-- https://master.php.net/note/delete/74783
Reject -- https://master.php.net/note/reject/74783
Search -- https://master.php.net/manage/user-notes.php