SELECT c.*, o.*
FROM SmtNtLight.dbo.MemberCounters AS c INNER JOIN 
   OPENROWSET('VFPOLEDB.1', 
   'c:\NT Light\Database\Setup.dbc';'';'',Members) 
   AS o
   ON c.Member_ID = o.Member_ID

The above returns

Server: Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for equal to operation.

I just scratched my head, looked in help, but how does one resolve this issue?

TIA