"Call to undefined .. mssql_connect" when using PHP in IIS?

Question

May is ask you about how to connect to Microsoft SQL server 2005 enterprise using PHP.

I am using Appserv 2.5.10 ( Apache 2.2.8, PHP 5.2.6) and SQL server 2005

After I place the extension download from this link :

http://www.microsoft.com/en-us/download/details.aspx?id=20098

enable the php.ini file by adding these lines.

extension=php_pdo.dll
extension=php_sqlsrv_52_ts_vc6.dll
extension=php_pdo_sqlsrv_52_ts_vc6.dll

Restart Apache using this code to connect

$link = mssql_connect($server, $user, $pass);

Error shown in browser is

Fatal error: Call to undefined function mssql_connect() in G:\AppServ\www\testmssql_connect.php on line 12

can anyone help me ?

NOTE: i am using windows server 2003 and i don't found this OS in OS supporting list of Microsoft Driver 3.0 for PHP. Is this issue cause the problem ?

Community · Accepted Answer · 2017-05-23 12:06:43Z

1

Look at this link:

PHP Fatal error: Call to undefined function mssql_connect()

1) Check your PHP.INI file's extension_dir

2) Make sure you copied your .dlls into that directory (for example, into C:\PHP\ext").

3) Create a dummy page to call phpinfo();. Display the page in a browser. Make sure you see entries for "sqlsrv".

'Hope that helps!

edited May 23, 2017 at 12:06

CommunityBot

11 silver badge

answered Jul 17, 2012 at 6:46

paulsm4

123k23 gold badges175 silver badges245 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ryan Over a year ago

why i type sqlsrv_connect () this function has the black text color instead of blue color (because of function) so should i use sqlsrv_connect or mssql_connect

paulsm4 Over a year ago

The new 3.0 API uses sqlsrv_connect(). I really find it shocking that people put such faith in their IDE, vs. understanding what the actual code is doing and how it works. There is not necessarily any "tight binding" between the IDE and the underlying implementation. The current MSSQL 3.0 driver documentation is here: php.net/manual/en/book.sqlsrv.php and blogs.msdn.com/b/sqlphp/archive/2011/09/24/…. Please do follow the steps above to make sure everything's configured correctly. 'Hope that helps...

Collectives™ on Stack Overflow

"Call to undefined .. mssql_connect" when using PHP in IIS?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related