Hello Michael
Some people have reported with the ADODB database class library that they
were having problems with inserts and updates when using mssql_pconnect.
Switching to regular mssql_connect the problems disappeared.
I suspect it has something to do with persistent connections having
Hello Adrian,
There are some concurrency issues with mssql if you are using
mssql_pconnect. Try switching to mssql_connect. Also check to see if
transactions are enabled in mssql.
Your SQL insert syntax looks ok.
Regards, John
PS: for porting mysql to mssql, have a look at
Hi John -
Can you elaborate on the concurrency issues?
Thanks.
John wrote:
Hello Adrian,
There are some concurrency issues with mssql if you are using
mssql_pconnect. Try switching to mssql_connect. Also check to see if
transactions are enabled in mssql.
Your SQL insert syntax looks
Can anyone help me?
Today I was informed that the backend for my project will not be MySQL, but MSSQL 7.0.
No problems, I said, but after porting database from MySQL to MSSQL I find that the
UPDATE statement doesn't work. Strange is that INSERT statement in a php query does
not work second
In article 001401c0bd38$51d05580$[EMAIL PROTECTED],
[EMAIL PROTECTED] says...
}Can anyone help me?
}Code is here:
}
}The same code and function work fine in MySQL. Why doesn't work in MSSQL Server???
}
Investigate the MSSQL Server UPDATE syntax carefully:
my_update("update sometable set col1=".$var1." where col2=".$var2);
and function:
function my_update($query){
global $host,$user,$psw,$name;
$conn=mssql_pconnect($host,user,psw) or die("Error: connection
failed!");
$rdb=mssql_select_db($name,$conn) or die("Error: DB does not
6 matches
Mail list logo
