Execute query activity does not recognize "*" wildcard


#1

Hello!

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?

Thanks!