Dynamics Axapta blog

Hi, The below code is used to connect the external DB to access tables from ax. (In this approach we eliminated the standard ODBC DSN configuration. which is time consuming process. because we have to setup the ODBC DSN in all client machine) static void GetCustomerInfoFromExternalDB(Args _args) {     System.Data.SqlClient.SqlConnectionStringBuilder     CSB;     System.Data.SqlClient.SqlConnection                  con;     System.Data.SqlClient.SqlCommand                     cmd;     System.Data.SqlClient.SqlParameterCollection         parmColl;     System.Data.SqlClient.SqlDataReader                  dataReader;     str                                                  sql,                                                         serverName,                                                         DatabaseName,                                                         conString;     System.Exception                                     InteropExcep

Hi, To invoke the other application from ax. we can use WinAPI class which is available in Axapta. the syntax is as follow, WinAPI::shellExecute("notepad");  //Path of the exe file //Path of the exe file with additional parameter WinAPI::shellExecute(       Filename    _lpFile,    str         _lpParameters      = '',    str         _lpDirectory       = '',    str         _lpOperation       = #ShellExeOpen,    int         _show              = #SW_SHOWNORMAL,    boolean     _waitForCompletion = false    )

Hi Friends, Welcome to my blog. I am Vijaykarthik, working as Ax technical consultant. I will share my experience, findings, technical help, tips and tricks regarding Ax 2012. Happy Daxing.