![]() Where the Query is: SELECT * from sometable WHERE somefield LIKE '%ABC%' ģ2 bit Office: Microsoft Office MSO 5.20280 32bitĦ4 bit Office: Microsoft Office MSO 5.20280 64bitĪccess database engine (圆4) from here: /en-us/download/details. X64 Office Installed: Installed Access 2016 圆4 Database Engine: Query PASSES No Office Installed: Installed Access 2010 圆4 Database Engine: Query PASSESģ2bit Office Installed: Installed Access 2016 圆4 Database Engine: Query FAILSģ2bit Office Installed: Installed Access 2010 圆4 Database Engine: Query PASSES So in summary: No Office Installed: Installed Access 2016 圆4 Database Engine: Query FAILS The binaries are referenced by the ASF, Microsoft, PHP etc. So the issue seems specific the Microsoft Access Database Engine 2016 Update: If I install the Microsoft Access 2016 Runtime then all seems to work. I have a query that checks: field 0 and this throws an exception. Note: the other query that seems to be failing is a table with a Yes/No field. So my question is are there changes in the way SQL is parsed in Microsoft Access Database Engine 2016 and should I simply get customers to install the 2010 version? I did look for some release notes/breaking changes but couldn't find anything. It seems that something is different in the Access Database Engine 2016. What I don't understand is if I install the Access Database Engine 2010 then all works as expected. Most noticeably ones that use LIKE '%somevalue%' - now I understand that % is ANSI-92 but it's been working fine as I say so assume that's ADO related (I could change this to ALIKE I guess). In general everything works OK but certain SQL queries are failing. So I grab Microsoft Access Database Engine 2016 Redistributable and install it. ![]() I have converted it to 圆4 and I believe I need to install some form of Access drivers no matter if the host PC has 圆4 Office installed or not. Using ADO in C++ on a PC with no Office installation. I have an app that's been working fine in 32 bit using the connection string: Driver= Dbq=MyDatabase.mdb
0 Comments
Leave a Reply. |