Dynamics Community Forum Thread Details

Method 'open' in COM object of class 'ADODB.RecordSet' returned error code 0x80040E21 (<unknown>) which means: ODBC driver does not support the requested properties.

hi,

iam using the below code to upload data

void insertIntoTmp()
{
    str                   conStr;
    str                   sqlStr;
    Filename              filename1;
    FilePath              filePath;
    filenameType          filenameType;

    ;
    cn=new CCADOConnection();
    [filePath, filename1, filenameType] = fileNameSplit(filename);

conStr = strfmt("PROVIDER=MSDASQL;DRIVER={MICROSOFT TEXT DRIVER (*.TXT; *.CSV)};DBQ=%1",filePath);
cn.open(conStr);

    rs = new CCADORecordSet();
    sqlStr = strfmt("select * from %1%2",filename1,filenameType);
    rs.open(sqlStr,cn,1,1);

    while(!rs.EOF())
    {
        txtLine = rs.fields().itemIdx(0).value();
        recordId = substr(txtLine,1,3);
        changeType = this.recordId2ChangeType(recordId);
        if(bse)
            this.bseLineBreak();
        else
            this.nseLineBreak();

rs.moveNext();

    }
    rs.close();
    cn.close();

info(strfmt('%1 Record is uploaded',i));

}

but getting error

Method 'open' in COM object of class 'ADODB.RecordSet' returned error code 0x80040E21 (<unknown>) which means: ODBC driver does not support the requested properties.

pls suggest

Quick Links