Re: mssql problems

I had this exact same problem and after a lot of time I switched to an ODBC connection (no mssql_connect... Just use the ODBC commands) and everything has worked flawlessly since. There's probably some right combination and way to use the mssql specific commands but life it too short and the ODBC stuff will do everything you need anyway. It worked first time and every time since for me. Good Luck, Frank On 4/19/02 1:54 PM, "php-db-digest-help@lists.php.net" <php-db-digest-help@lists.php.net> wrote: > -----Original Message----- > From: Rob Fraser [mailto:rob.fraser@elmwood.co.uk] > Sent: 19 April 2002 08:44 > To: php-db@lists.php.net > 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 -- Frank Flynn Poet, Artist & Mystic