I have simplified it to the code below in Microsoft Visual C++. It is still giving me the same error ("Driver does not support this function"). I am using Max 7. I have confirmed that there is a user call MASTER and the password is control. It may be important to note that I can get information out of Maximizer with Access. So I know the DSN works, at least some of the time. NannyNetworkMaxDB uses the Max ODBC driver
I have tried changing ' "DSN=NannyNetworkMaxDB;Uid=MASTER;Pwd=control;", CDatabase::noOdbcDialog ' to NULL so that it asks me to select a DSN and enter the username and password. This also results the same error so I don't think the problem is with the connection string. I've also created another user in the Max Admin Program, which doesn't work either. It is still giving me the same error ("Driver does not support this function").
Lastly I have tried using the Persuasive ODBC Driver, but I get an error saying "Unable to open table: CLIENT. No such table or object.". This seems like more progress, but I'm not sure why the Persuasive driver can't find a table that does exist???
Anyways here is the code, any help would be hugely appreciated:
void CNannynetworkcppDlg::Test()
{
CString id, notes, sql;
CDatabase m_max;
m_max.OpenEx("DSN=NannyNetworkMaxDB;Uid=MASTER;Pwd=control;", CDatabase::noOdbcDialog);
CRecordset m_max_info(&m_max);
m_max_info.Open(CRecordset::snapshot,"SELECT * FROM CLIENT WHERE Record_Type = '2'");
while(!m_max_info.IsEOF()) {
MessageBox("select successful", "" , MB_OK);
}
m_max.Close();
}