1. Home
  2. Point-Of-Sale Software
  3. unknown "Invalid attribute/option identifier" error

unknown "Invalid attribute/option identifier" error

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

Reply to
Aldo
Loading thread data ...

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

Reply to
root

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:

Reply to
Aldo

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.