ODBC Connection to an other Database

Finance and Operations/AX Developer Forum
1

Hello out there,

I run Dynamics AX on MS-SQL-Server. Is there a possibility to open up an ODBC connection from within X++ to an external Oracle Database to execute PL-SQL commands? If the answer is yes, could you please provide some sample code?

Thank you very much in advance!

2

You should check out the ODBCConnection class under System documentation\Classes.

(you will notice also the connection class (parent) and the userConnection classes)

You can simple put a search on AOT with text containing the name of the class and you will get a couple of examples at least.

Good luck!