You should be able to instantiate and call the COM connector from TSQL using the sp_OACreate stored procedure. I haven't tried it myself so I haven't got any experience on this.
Regards
Thomas
-----Oprindelig meddelelse-----
Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] På vegne af mbsaxapta
Sendt: 14. april 2006 10:27
Til: Axapta-Knowledge-Village@yahoogroups.com
Emne: [Axapta-Knowledge-Village] tight integration on external software
Hi all,
I would like to create connection from external software (on MS SQL server)
to Axapta. Because of RecID etc. you know it would be better to build it on
application level via COM connector. Does exist any way how I can run it in
triggers or in stored procedures in external software database? For example
whenever external sw create some record in the table run script with
AxaptaCOMConnector...
thanks in advance,
tom
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course | Business to business finance | Small business finance |
Business finance consultant | Business finance magazine | Business finance schools |
YAHOO! GROUPS LINKS
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.