I am trying to connect to the SQL Server and then to create a database table using PHP script. The code is as follows,[php]<job id="sqlserver1" >
<script language="PHPSc ript">
$connection = mssql_connect(' UIE-LAPTOP-01\SQLEXPRESS', 'pugalenthi' , 'Qwert1!');
mssql_select_db ('tempdb', $connection);
$sql = "CREATE TABLE Catalog(Catalog Id VARCHAR(25), Journal
VARCHAR(25), Publisher Varchar(25), Edition VARCHAR(25), Title
Varchar(45), Author Varchar(25))";
mssql_query($sq l);
</script>
</job>[/php]when i tried to run this script in a windows script host file, i got an error. The error was "call to undefined function mssql_connect() . Please help me.
<script language="PHPSc ript">
$connection = mssql_connect(' UIE-LAPTOP-01\SQLEXPRESS', 'pugalenthi' , 'Qwert1!');
mssql_select_db ('tempdb', $connection);
$sql = "CREATE TABLE Catalog(Catalog Id VARCHAR(25), Journal
VARCHAR(25), Publisher Varchar(25), Edition VARCHAR(25), Title
Varchar(45), Author Varchar(25))";
mssql_query($sq l);
</script>
</job>[/php]when i tried to run this script in a windows script host file, i got an error. The error was "call to undefined function mssql_connect() . Please help me.
Comment