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

Best regards,

Stephen Schadt
Technical Support Consultant
OpenLink Software

"Joachim Schade" <[EMAIL PROTECTED]> wrote in message
> Hi,
> 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 (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to