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


-----Original Message-----
From: Rob Fraser [mailto:[EMAIL PROTECTED]]
Sent: 19 April 2002 08:44
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

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to