SELECT *
FROM OPENROWSET(
      'SQLOLEDB',
      'Data Source=hydrogen;User ID=scratch;Password=scratch;',
      'select * from users')

SELECT *
FROM OPENROWSET(
      'SQLOLEDB',
      'Provider=SQLOLEDB;Data Source=hydrogen;User ID=scratch;Password=scratch;',
      'select * from users')

SELECT *
FROM OPENROWSET(
      'SQLNCLI10',
      'Data Source=hydrogen;User ID=scratch;Password=scratch;',
      'select * from users')

SELECT *
FROM OPENROWSET(
      'SQLNCLI10',
      'Data Source=hydrogen;User ID=scratch;Password=scratch;',
      'select * from users')

SELECT *
FROM OPENROWSET(
      'SQLOLEDB',
      'Data Source=hydrogen;Integrated Security=SSPI;',
      'select * from users')