PHP 4.0.4 and MSSQL

[Anon]

I just installed php 4.0.4 on a W2K with IIS 5.0 and SQL Server 7.0.

Every INSERT in a mssql_query() function return FALSE. It works ok with php 4.0.3pl1.

.
.
.
$res = mssql_query("INSERT ...", $con);
if($res == FALSE) {
print "Error";
}
.
.
.
A bug of php, or mine? :-)

[Anon]

you can use odbc to try.

[Anon]

Hi there,

It seems your php4 is working fine with mssql. I have the proplem with connection to mssql server. Did I miss something ??? Any help would be appreciated. Thanks

[Anon]

I use NT4.0 and mssql + php4, you can find the Console ---> ODBC resource in NT4.0, can you open it,Ok!
In the System DSN, you can select a database SQL SERVER,OK,click ADD,Please fill in the blank...
In your php file,can you use the ODBC to connect the MSSQL,for example :
<?php
$conn=odbc_connect("mydb","sa","");
&query = "INSERT INTO mytable (jor_from, jor_to) VALUES('$from',

'$to')";
$result = odbc_prepare($conn,&query);
if (!odbc_execute($result)) {
echo "error";
}
odbc_close($conn);
?>
<?php
$conn = odbc_connect("WebDB", "sa", "");
$query = "select user, idno ";
$query .= "from userinfo";
$result_id = odbc_do($conn, $query);
while(odbc_fatch_row($result_id)) {
$user = odbc_result($result_id, 1);
$idno = odbc_result($result_id, 2);
echo $user."\'s id card is ".$idno."<br>\n";
}
odbc_close($conn);
?>