I am reading input data with SQLexecute and all of them work well except the ones that the selection uses a conditional 'WHERE', like this one:
SQLexecute("SELECT Xcoord,Ycoord FROM " + NODE_DATA + " WHERE [Node] = " + nn, NODE_COORDS(nn));
The problem occurred only in a new Windows 10 installation with Xpress IVE and Workbench 8.4.2 64-bit. While in Windows 7 and Workbench 8.4.0 64-bit there was no problem at all.
I have tried to reinstall the AccesDatabaseEngine_X64.exe, but it does not work.
Libraries loaded: "mmodbc", "mmsystem", "mmsheet"
Is there anything from SQLexecute that I am not aware of? Or might be a system installation issue?
Edit: Error message [Microsoft][ODBC Excel Driver] Internal OLE Automation error, SQLSTATE=22018