Saturday, September 28, 2013

ODBC Connection in AX 2012

static void RMTODBCConnection(Args _args)
{
    LoginProperty loginProperty;
    ODBCConnection odbcConnection;
    Statement statement;
    ResultSet resultSet;
    ResultSetMetaData resultSetMetaData;
    Counter counter;
   
    ;
   
    loginProperty = new LoginProperty();
    loginProperty.setDSN("Test"); // Datasource name for the Axapta database
    odbcConnection = new ODBCConnection(loginProperty);
    statement = odbcConnection.createStatement();

    resultSet = statement.executeQuery("select * from CustTable");
    resultSet.next();
    resultSetMetaData = resultSet.getMetaData();
    for (counter=1; counter <= resultSetMetaData.getColumnCount(); counter++)
    {
        switch (resultSetMetaData.getColumnType(counter))
        {
            case 0,1 :
            info(resultSet.getString(counter));
            break;
            case 3 :
            info(date2StrUsr(resultSet.getdate(counter)));
            break;
        }
    }
}