Post reply

BDE x SQLServer (2005/2008) - Compatibility mode

  • November 17, 2010 at 1:05 pm

    #226772

    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.

  • November 17, 2010 at 1:41 pm

    #1252142

    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

  • November 18, 2010 at 4:55 am

    #1252397

    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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy