Skip to Content
avatar image
Former Member

could not update SAP hANA table through SQL procedure openrowset

Hi ,

I am using SQL procedure to get the data from SAP HANA and displaying in the devexpress grid in application.The select query works fine using openrowset.But when i use for update i am getting error.Here is my code.

update t set t.TechName='1' from OPENROWSET( 'MSDASQL', 'Driver=HDBODBC;;UID=SC000477;PWD=Amma@100;', ' select * from "BODS_CSW"."BSNA_iPerform_Tech_Mapping" where "PersonelNumber"=598230 ' ) as t

This is the error i am getting .

OLE DB provider "MSDASQL" for linked server "(null)" returned message "[SAP AG][LIBODBCHDB DLL][HDBODBC] Base table not found;259 invalid table name: Could not find table/view BSNA_iPerform_Tech_Mapping in schema SC000477: line 1 col 8 (at pos 7)". Msg 7343, Level 16, State 4, Line 1 The OLE DB provider "MSDASQL" for linked server "(null)" could not UPDATE table "[MSDASQL]".

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers