problem in connecting php with mssql

[meenakshidhar]

I m using PHP with MSSQL...i have installed FREETDS in my linux box...MSSQL 2000 is on WIN2000 machine..on my linux box i m already using PHP and MYSQL...which is working fine...but i m not abble to connect to MSSQL using PHP...
my code is as follows..
<?
$msconnect=mssql_connect(&quot;serverip&quot;,&quot;username&quot;,&quot;pass&quot or die(&quot;could not connect server&quot;
$msdb=mssql_select_db(&quot;dbname&quot;,$msconnect);
$msquery = &quot;select * from tablename&quot;;
$msresults= mssql_query($msquery);
while ($row = mssql_fetch_array($msresults)) {
echo &quot;<li>&quot; . $row['fieldname']. &quot;</li>\n&quot;;
}
?>
the error which i m getting is--
Fatal error: Call to undefined function: mssql_connect() in /var/

http://www/html/ip/print.php

on line 3

is there anything i m missing...i want to use mysql and mssql both with php...
urgent help needed...

Regards
Meenakshi Dhar

 

[Chacalinc]

According to the error, this is a PHP problem, it has not the module compiled or it is missing.

From

http://www.php.net/manual/en/ref.mssql.php

Installation

The MSSQL extension is enabled by adding extension=php_mssql.dll to php.ini.

To get these functions to work, you have to compile PHP with

--with-mssql[=DIR]

, where DIR is the FreeTDS install prefix. And FreeTDS should be compiled using --enable-msdblib.

 

[sleipnir214]

meenakshidhar:
Write a script which consists of:

<?php
phpinfo();
?>

put it on your web server and point your web browser to it. Does the output contain a section titled &quot;mssql&quot;?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!