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
You can reply with the output of this. Please reply to
Technical Support Consultant
"Joachim Schade" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I use PHP 4.0.6 with iODBC and Apache 1.3.20 on a Linux System to connect
> 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
> 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
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]