I am using this new oledb extension for creating a prepared statement..with following lines of code... $oConRef= oledb_connect($Host,$DBUserName,$DBPassword); $oConRef= oledb_select_db($DBName,$oConRef); $statement=oledb_prepare("Update table XUSER where user_type=?"); oledb_bind($statement,'@user_type',$user_type,OLEDB_VARCHAR); $rdxdata=oledb_execute($statement); while($row = oledb_fetch_array($rdxdata)) { $dd=$row['user_type']; echo "\n".$dd; } is showing following error if i am going for a bind statement... [b]Warning: oledb_bind() [function.oledb-bind]: Unsupported type [/b] could u plz correct me where m wrong. Is there any syntax error which is creating problem..if so then what will be the correct code for this./. I want to prepare a prepared statement for my query which is being called for diffent user types...at different- different places.so i need to bind different values for "user type " with the same query. i am using PHP 5.0,MS SQL 2000 and oledb combination. plz help me out...its quite urgent. thanks, oops