November 17, 2010 at 1:05 pm
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
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
November 18, 2010 at 4:55 am
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
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