BDE x SQLServer (2005/2008) - Compatibility mode

  • Hello!,

    Anybody know if the the SQLServer run without compatibility mode with the BDE?

    My problem is that in the moment of open a component of data access I receive that message:

    The query uses non-ANSI outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibility level for current database to 80, using the SET COMPATIBILITY_LEVEL option of ALTER DATABASE. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes.

    Only execute if a compatibility mode as 80, if compatibility mode is 90 or 100, appears the message up.

    The SQL command it is internal of component, I can not modify.

    I call "ComponentName.Open" for example.

    My BDE Version is 5.2.

    Thank's

    Fernando.

  • Fernando,

    Just to make sure that I'm on the right page with you, BDE is the Borland Database Engine? If so, the BDE was last updated to work with the SQL Driver in SQL 7. I'd suggest converting from the BDE to ADO.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • Wayne,

    Yes, the BDE is the Borland Database Engine. I managed to run SQL 2000 (80). From the information I got, but even the best option is upgrading to ADO.

    Thank you.

    Fernando.

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

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