Post reply

General SQL Error

  • January 15, 2008 at 11:26 am

    #180660

    We have an Ultipro Application accessing a SQL 2k5 Database (Version

    9.00.2047.00) on W2K3R2 Sp2.

    Error message as follows;

    [General SQL Error. The query uses non-ANSI outer join operators ("*=" or

    "=*"). To run this query without modification, please set the

    compatibility...]

    TIA

  • January 15, 2008 at 11:44 am

    #768264

    SQL 2005 does not support JOINS that uses *=. If you still want it to work, you will have to put SQL in either 7 or 8 compatability Mode. But you will loose all the gain of SQL 2005.

    -Roy

  • January 15, 2008 at 12:25 pm

    #768283

    Up their support forced the upgrade, and now we moved back to Version 8 to make the app run. Fixed now. Feel free to provide commentary, makes me feel better.

  • January 15, 2008 at 12:32 pm

    #768285

    You might suggest that they test their code under SQL Server 2005 before asking you to upgrade to 2005.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply