mssql not loaded

[newphpcoder]

Good day!

I try a lot of configuration to work my connection from php to mssql but still I cannot connect. And I got a code to check if the mssql was loaded.

Here is the code:

<?php
if (function_exists('mssql_connect')){
echo "Okay, fn is there<br>------------------<br>";
} else {
echo "Hmmm .. fn is not even there<br>------------------<br>";
}

if(extension_loaded("mssql")) {
echo "MSSQL is Loaded<br>";
}
else {
echo "MSSQL not loaded<br>";
} 

if(extension_loaded("msql")) {
echo "MSQL is Loaded<br>";
}
else {
echo "MSQL not loaded<br>";
} 
echo '<br><br>';

$ext = get_loaded_extensions();
if(in_array('mssql', $ext))
echo 'u have mssql installed<br><br>';
else
echo 'u do NOT have mssql installed<br><br>';

phpinfo();
?>

And when I run this code the result is:

Hmmm….fn is not even there
----------------------
MSSQL not loaded
MSQL not loaded
You do NOT have mssql installed
And the list of phpinfo() appear.

Actually I run this code when my php version is php 5.2.4 and now I try it to php 5.1.4 and the result is still the same.

Web server is IIS 6.0
OS is Windows Server 2003 R2 Standard Edition
PHP version is php 5.1.4
MS SQL Server 2005 Express Edition –Windows Authentication.

I need to solved this problem because my connection in mssql is not working because call to undefined the function mssql_connect().

I hope somebody can help me. Almost three weeks I configure this connection and still I cannot connect.

Any help is highly appreciated.
Thank you.

[Hack]

What connection string are you using?

[newphpcoder]

What connection string are you using?

mssql_connect()

[gmarut]

Not sure if this helps at all, but a few years back I converted my website from using PHP/MySQL to PHP/MSSQL and noticed a severe problem with memory leaks. With MSSQL better for what we needed it to do, I then switched PHP to ASP.NET which then elminated the memory leak issue.

My point being, I suspect that the two technologies do not function well together (unless I just had poor code).

[tkorsano]

hi there,

look at this page http://php.net/manual/en/function.mssql-connect.php
and search for version and find your answer.
what i am trying to tell you is that you need a sql server connect method which matches your php version.

best regards,

tonci.

[newphpcoder]

hi there,

look at this page http://php.net/manual/en/function.mssql-connect.php
and search for version and find your answer.
what i am trying to tell you is that you need a sql server connect method which matches your php version.

best regards,

tonci.

when I used mssql_connect() it works but my only problem is connect to database. I think i need to configure my sql server but I don't what I need to configure.