I’m using the Execute Query activity and connecting to an .accdb MS Access database using the OLEDB connection (
Provider=Microsoft.ACE.OLEDB.12.0;). I have predefined queries in the database that uses the asterisk (
*) as a wildcard. The query runs fine in MS Access, but when I run the query from UiPath, the query does not return any results.
I think that the issue is that my database queries is written using the ANSI-89 standard, while the UiPath database connection is using the ANSI-92 standard. According to this Microsoft support page, ANSI-89 uses
* as a wildcard and ANSI-92 uses
% as a wildcard. Based on my research, OLEDB uses ANSI-92 by default.
So my question: is there any way to configure the UiPath activity to use ANSI-89 style query strings?