RE: troubles with select * from... to a ms-sql-server

Have you tried removing the [] brackets? And what is ReferencesComplete - a standard table, a view or a stored procedure? Ollie -----Original Message----- From: Hermann Otteneder [mailto:h.otteneder@gerstl.at] Sent: 17 April 2002 16:30 To: php-db@lists.php.net Subject: troubles with select * from... to a ms-sql-server hi, i try to get some data from our ms-sql-server the following statement: $SQL = "SELECT * FROM [ReferencesComplete]"; causes an error of the php.exe! i tried many various of this statement but nothing helped. ether it came no error and the [$result = mssql_query($SQL,$IDconnection);] variable was false or the php.exe crashed! with mysql it workes ok but with the ms-sql-server not! please give me help - this so what simple - but does not work - i lost so much time... hermann