We feed a sister system with customer data that's entered on GP 9.0. I have a central database (MSTR) that houses all the customers then there is a trigger on the RM00101, 102 and 103 that blows the data out to the other 43 companies that we have on GP. That works fine-it's all on the same server.
The trigger that doesn't work sends it to a linked server that's also SqlServer 2005. When I enter the data (in GP/Cards/Sales/Customer) and hit save I get:
[Microsoft][ODBC SQL Server Driver][SQL Server]Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.
EXCEPTION_CLASS_DB
DB_ERR_SQL_OBJ_NOT_FOUND
I've modified my ODBC setting that I log into GP with and that doesn't help. Are ANSI_NULLS/ANSI_WARNINGS set by the application?!?! If it is, I'm screwed. From what I've read online, you can't change these settings from a trigger, it HAS to be the application and/or Enterprise manager that does this. Surely someone has had to do a trigger off new customer additions.
*This post is locked for comments
I have the same question (0)
