Skip to Content
0
Former Member
May 21, 2015 at 07:02 AM

SQL 2008 R2 Query error

95 Views

Hi SQL DB Experts,
Need your help on changing the DB accepting query in case insensitive.

DB: SQL Server 2008 R2

Installed DB Collation: SQL_Latin1_General_CP850_BIN2
and Installed SAP Business Objects Data Services

Error:
[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'DESCRIPTION'.>. The SQL submitted is <SELECT "PROD_NAME", "PROD_RELEASE", "EXTRELEASE", "DESCRIPTION" FROM "dbo"."DQ_SAP_PRODUCT_VERSION" >.
(14.2) 05-20-15 21:25:20 (E) (19500:13836) DBS-070404: |Session Job_Realtime_DQ_SAP_Product_Version|Data flow DF_Realtime_DQ_SAP_Product_Version|Reader DQ_SAP_PRODUCT_VERSION SQL submitted to ODBC data source <> resulted in error

When I reun the same query from Studio

Query which got error:
SELECT "PROD_NAME", "PROD_RELEASE", "EXTRELEASE", "DESCRIPTION" FROM "dbo"."DQ_SAP_PRODUCT_VERSION"
Error:
Msg 207, Level 16, State 1, Line 1
Invalid column name 'PROD_NAME'.
Msg 207, Level 16, State 1, Line 1
Invalid column name 'PROD_RELEASE'.
Msg 207, Level 16, State 1, Line 1
Invalid column name 'EXTRELEASE'.
Msg 207, Level 16, State 1, Line 1
Invalid column name 'DESCRIPTION'.

Same Query columns as like Database Table successful.
SELECT "Prod_Name", "Prod_Release", "ExtRelease", "Description" FROM "dbo"."DQ_SAP_PRODUCT_VERSION"

=>Got result,.

Could you help me how to change Database table to accept the Query in either of the case ( remove Case sensitive)

Thank you,

Ramesh