SQL DB Access error

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

SQL DB Access error

Post by JB429 » Tue Sep 23, 2008 8:32 pm

When generating a report from an SQL table called "scale" we receive the following error:____"DB access: [Microsoft][ODBC SQL Server Driver][SQL Server] The column prefix _scale_ does not match with a table name or alias name used in the query. [Microsoft][ODBC SQL Server Driver][SQL Server] The column prefix _scale_ does not match with a table name or alias name used in the query. [Microsoft][ODBC SQL Server Driver][SQL Server] Statement(s) could not be prepared."____What is causing this error?
Top
kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: SQL DB Access error

Post by kfleming » Wed Sep 24, 2008 8:48 pm

Is this happening in the report designer?__Is SCALE the only table that is used in the report and is it a view table?____Kathleen__R&R Support
Top
Post Reply

Return to “R&R ReportWorks Users”