I’m new to AIMMS and I’m following the tutorial for professional. I’m in page 80 now and while running the procedure ‘ReadFromDatabase’, I encounter an error saying,
“Executing SQL query "TotalDemand" of database procedure "TotalDemandQuery" failed: ODBC[-3500] : 42000 [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. [while calling the query TotalDemand].”
I don’t understand this error as the tutorial does not say anything on this issue and I think I’ve followed the tutorial completely.
Any help, please?
Can you check if you have selected “Stored Procedure” and not “Sql Query” in the TotalDemandQuery identifier?
Yes, I’ve selected for the “Stored Procedure” in the identifier. It still gave the error.
Strangely enough, I open again the case just now and it works perfectly . Thanks anyway ya