note 80843 added to ref.mssql
| From: | Jaga at osu1 dot php dot net | Date: | Sun, 03 Feb 2008 00:04:28 +0000 |
| Subject: | note 80843 added to ref.mssql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-135743@lists.php.net to get a copy of this message | ||
Ok, I am using wamp server and Code Igniter framework and SQL Server 2005. I had that annoying
'called to undefined function mssql_(...)" problem. That's how I have solved it:
1. I've downloaded ntwdblib.dll 2000.80.194.0 version and I've pasted it to php directory.
2. I've copied all those php_mssql.dll and ntwdblib.dll to:
2.1 windows/system 32
2.2 php directory
2.3 apache/bin
3. I've enebled 'extension=php_mssql.dll in':
3.1 php dir
3.2 apache/bin
4. I've enebled pipes in MSSQL, allowed all IPs in TCP/IP of mssql and started SQL Browser
5. In system/application/config/database.php I use these parameters:
$db['default']['hostname'] = "localhost";
$db['default']['username'] = "sa";
$db['default']['password'] = "password";
$db['default']['database'] = "the_name";
$db['default']['dbdriver'] = "mssql";
$db['default']['dbprefix'] = "";
$db['default']['active_r'] = TRUE;
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
AND IT WORKS :D !
----
Server IP: 82.177.164.100
Probable Submitter: 87.105.6.195
----
Manual Page -- http://www.php.net/manual/en/ref.mssql.php
Edit -- https://master.php.net/note/edit/80843
Del: integrated -- https://master.php.net/note/delete/80843/integrated
Del: useless -- https://master.php.net/note/delete/80843/useless
Del: bad code -- https://master.php.net/note/delete/80843/bad+code
Del: spam -- https://master.php.net/note/delete/80843/spam
Del: non-english -- https://master.php.net/note/delete/80843/non-english
Del: in docs -- https://master.php.net/note/delete/80843/in+docs
Del: other reasons-- https://master.php.net/note/delete/80843
Reject -- https://master.php.net/note/reject/80843
Search -- https://master.php.net/manage/user-notes.php