#include "ODBCDSNless.h"

// Constructor
ODBCDSNless::ODBCDSNless(CString strFile, CString strTable, CString strColumn, CString strCondition): ODBCRead(strFile,strTable,strColumn,strCondition) {
    m_strFile = strFile;
    connectString();
    read();
};

// Build connection string
void ODBCDSNless::connectString(void) {
    if (m_strFile.Find(_T(".xls")) >= (int)0) {
        m_strDriver = _T("EXCEL DRIVER (*.xls)");
    } else if (m_strFile.Find(_T(".mdb")) >= (int)0) {
        m_strDriver = _T("ACCESS DRIVER (*.mdb)");
    } else {
        fail = true;
        AfxMessageBox(_T("Unrecognised type of file; extension must be either .xls or .mdb"));
        ODBCRead::~ODBCRead();
        return;
    }
    m_strConnect.Format(_T("ODBC;DRIVER={MICROSOFT %s};DSN='';DBQ=%s;UID='';PWD='';"), m_strDriver, m_strFile);
}