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?
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
Can you check if you have selected “Stored Procedure” and not “Sql Query” in the TotalDemandQuery identifier?