Page 1 of 1

SQL DB Access error

Posted: Tue Sep 23, 2008 8:32 pm
by JB429
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?

=> RE: SQL DB Access error

Posted: Wed Sep 24, 2008 8:48 pm
by kfleming
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