在AX中使用SQL-DSN连接

static void Job3(Args _args)
{
    LoginProperty   LP ;
    OdbcConnection  dbConn;
    Statement       sqlStatement;
    Statement       sqlS;
    ResultSet       sqlResult;
    ;

    LP = new LoginProperty();
    LP.setDSN('AX');

    LP.setDatabase('Dynamics');

    dbConn = new OdbcConnection(LP);

    sqlStatement = dbConn.createStatement();

    sqlResult = sqlStatement.executeQuery("select *,SalesId from salesLine where recId = '5637144576'");

    sqlResult.next();

    info(strfmt("%1 , %2",sqlResult.getString(1),sqlResult.getString(2)));
}