Re: ORDER BY problem with iODBC and MS SQL-Server

Joachim, Are you using OpenLink drivers? If so, please verify if you can run the query using the OpenLinkODBC SDK sample "odbctest" application. If you can, then this issue is specific to PHP. Please trace this from the $ODBCINI file via [ODBC] Debugfile=/tmp/odbc.out You can reply with the output of this. Please reply to technical.support@openlinksw.com. Best regards, -- Stephen Schadt Technical Support Consultant OpenLink Software http://www.openlinksw.com "Joachim Schade" <jos@ifak.fhg.de> wrote in message news:20010821135828.84210.qmail@pb1.pair.com... > Hi, > > I use PHP 4.0.6 with iODBC and Apache 1.3.20 on a Linux System to connect a > MS SQL-Server Database on a Windows NT 4 System. > For example, the query "SELECT * FROM test" works successfully. But when I > try to add a ORDER BY clause in this statement like "SELECT * FROM test > ORDER BY name" the result ist always only 1 row although there are more rows > in the table. > As the ORDER BY problem when I add a DISTINCT in the statement it dosn't > works too. > > Who can help me? > > Thanks Joachim > > >