SQL2012 Compatability

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
tcarter
Posts: 5
Joined: Tue Oct 10, 2017 12:44 pm

SQL2012 Compatability

Post by tcarter » Wed Apr 24, 2013 9:08 am

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?

User avatar
cstrasser
Posts: 155
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: SQL2012 Compatability

Post by cstrasser » Wed Apr 24, 2013 9:13 am

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.
Chris Strasser
Liveware Publishing, Inc.
Work bigger.

Terry_(Guest)
Posts: 10
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: SQL2012 Compatability

Post by Terry_(Guest) » Thu Apr 25, 2013 5:36 pm

Thank you this resolved the problem

tcarter
Posts: 5
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: SQL2012 Compatability

Post by tcarter » Thu Apr 25, 2013 5:36 pm

Thank you, this resolved the problem

Post Reply