non-ANSI

[StevenZog]

I have an employee using R&R Report Writer version 10. She is attempting to join two SQL Server 2005 tables together. This is the error she is getting:____"DB access: [Microsoft][ODBC SQL Server Driver][SLQ Server] 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 or lower, using stored procedure sp_dbcmplevel. It is strongly recommended to rewrite the query using ANSI outer join operatores (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"____Does anyone know how I fix this without changing the database compatibility mode? Do I need to upgrade to the latest version of R&R?

[kfleming]

Edit the SQL Server section of the file RSWSQL.INI and remove the line that says DatabaseOuterJoinStyle.__This will change the format of the SELECT that is generated.____Kathleen__R&R Support

[StevenZog]

That did it! Thank you very much!