unknown "Invalid attribute/option identifier" error

Jun 29, 2006 2 Replies

hi, i have a trigger in mssql wich should update a table in a msaccess database using the OPENROWSET, it is activated after an update action in the 'Item' table of the MSSQL



this is the trigger:

 /* Trigger body */ UPDATE  OPENROWSET('Microsoft.Jet.OLEDB.4.0','\\nas1\workware\OrderManager\MyData.mdb';'Admin';'********',Inventory) SET Barcode = Inserted.ItemLookupCode FROM Item, Inserted WHERE LocalSKU IN ( SELECT SubDescription3 FROM Item WHERE ItemLookupCode Inserted.ItemLookupCode) 



and this is the error it is returning me: [code] [OLE/DB provider returned message: [Microsoft][ODBC Microsoft Access Driver]Invalid attribute/option identifier] [/code]



Special Notes:



  • The query was tested with good results, i used this for testing:
     /* Trigger body */ UPDATE  OPENROWSET('Microsoft.Jet.OLEDB.4.0','\nas1\workware\OrderManager\MyData.mdb';'Admin';'********',Inventory) SET Barcode = Item.ItemLookupCode FROM Item WHERE LocalSKU IN ( SELECT SubDescription3 FROM Item WHERE ItemLookupCode = '10155A54') 
  • The mssql server daemon has full access to the "\nas1" device.
  • The error its produced when I update the "ItemLookupCode" field in the real word, it means using the RMS Store OPerations Manager

Thanks in advanvce


this first things I think of are Datatype compatibility between the fields or maybe an MDAC issue.

as I said the query works fine outisde of RMS, since datatypes are the same, and the query structure its prety clean... how can i troubleshoot this?

Aldo

"root" wrote:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required