unknown "Invalid attribute/option identifier" error

• Aldo Zavala

  Mr or Mrs. 500

  Points: 507

  More actions

  June 29, 2006 at 2:25 pm

  #60918

  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:

  [OLE/DB provider returned message: [Microsoft][ODBC Microsoft Access Driver]Invalid attribute/option identifier]

  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 in the sofware we're using at the office, its called Microsoft Retail Mangamentet System (RMS)

  NOTE: Datatypes are the same, as I said query worked fine outisde of the 'Microsoft Retail Mangamentet System', and its structure its prety clean sql.

  Thanks in advance