AnsweredAssumed Answered

SQLexecute SELECT problem

Question asked by hectorepost@gmail.com on Mar 8, 2018
Latest reply on Mar 9, 2018 by Susanne.Heip

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

 

Thanks

Outcomes