Page 1 of 1
SQL2012 Compatability
Posted: Wed Apr 24, 2013 9:08 am
by tcarter
Hi__Recently moved to SQL2012 and many existing reports no longer work with R&R version 12.0.0.2, the error message complains about the syntax.Is this resolved in 12.5 or do the reports need a rewrite?
=> RE: SQL2012 Compatability
Posted: Wed Apr 24, 2013 9:13 am
by cstrasser
The issue is probably with the syntax used for handling left outer joins. Are you using SQL Server?____If so, edit the file RSWSQL.INI and search for the SQL Server section:____;;;;;;;;;;;;;;;;;;;;;;__;;; ;;;__;;; SQL Server ;;;__;;; ;;;__;;;;;;;;;;;;;;;;;;;;;;__[SQLServer]__DataSourceDBMS = Microsoft SQL SERVER__DataSourceOuterJoinStyle = 1______*********************__Comment out the DataSourceOuterJoinStyle line by adding a semicolon at the beginning of the line.
==> RE: SQL2012 Compatability
Posted: Thu Apr 25, 2013 5:36 pm
by Terry_(Guest)
Thank you this resolved the problem
==> RE: SQL2012 Compatability
Posted: Thu Apr 25, 2013 5:36 pm
by tcarter
Thank you, this resolved the problem