MSOLEDBSQL syntax when using OPENROWSET
OLEDB connections using the MSOLEDBSQL driver should use this format:

SELECT c.*
FROM OPENROWSET(
    'MSOLEDBSQL'
    , 'Server=MyServer;Database=tempdb;UID=test;Pwd=Test;'
    , 'SELECT name FROM sys.databases;'
    ) c;


ConnectionStrings.com is invaluable for obtaining valid connection string details.