Hi PHP Is quite cool isn't it.... As for your problem you might want to try a few things:
- Running PHP as the ISAPI module & make sure you have the latest version (you should get the latest version anyway). - Removing this line : $r = mssql_rows_affected ( $link); - as there is a mysql function for this but not mssql - it should have read - mssql_rows_affected($result) anyway I believe - it works on the result rather than the connection). Can't really think of any thing else without more info, although I've had bad experiences with trying to run MSSQL / IIS on the same NT4 box (although on 2000 and XP it's fine) - one of my colleages solution was to run Apache for win32 instead of IIS as there appeared to be clashes between SQL and IIS (something we have since rectified). Good luck Ollie -----Original Message----- From: Rob Fraser [mailto:[EMAIL PROTECTED]] Sent: 19 April 2002 08:44 To: [EMAIL PROTECTED] Subject: mssql problems Dear All, I hope somebody can help me. I am new to PHP (I've used ASP for three years:-( ) and I'm loving PHP and trying to get my work to convert but I've coming across a error with mssql_query() explorer its just crashes with a php.exe 'memory could not be read error'. I'm sure it a school boy error from me but I'm just stuck, please help me code is...... =========== $link = mssql_connect ("laptop", "sa", "elmwood"); print ("<br>LINK was $link"); $back = mssql_select_db ( "elmback",$link); print("<br>back was $back"); $query = "SELECT * FROM tblperson"; print("<br>query was $query"); $result = mssql_query($query,$link); //JUST CRASHES ON THIS LINE $r = mssql_rows_affected ( $link); print("<br>rows affected was $r"); $close = mssql_close ($link); print("<br>close was $close"); ========= I run IIS4, NT4 (SP6a) and SQL 7 on the same machine as its my development one, out of date maybe but you should see my clothes but PHP was test downloaded a month ago - any ideas from a white knight? best regards Rob -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
