Connecting to a MS SQL Database

[alfpalafox]

Hello all,

I have a problem connecting to a MS SQL databse, I have this code:

<?php
function conexion()
{
$con_id = mssql_connect("ServerName", "Username", "Password");
mssql_select_db("DB");
return ($con_id);
}
?>

But I get this error:

Fatal error: Call to undefined function: mssql_connect() in conexion_bd.php on line 4

Could anyone help me please??

[scopex3]

depending on what type of system you're running on... such as if you're running a Linux or Unix box, you're going to have to install Sybase extensions and then re-compile PHP inorder for the the MS SQL to work. I ran into this problem while doing this with a Red Hat Linux 7.3 box. After much pain, the Linux box can access the MS SQL 2000 server across the network and give back good results.