Codebase OLE DB Provider (v 6,3) to create SQL Server linked server

Hi all,

I am trying to use the codebase ole db provider -created in v 6.3- to
create either:
1) A Linked server to a foxpro database table, or
2) use OPENROWSET to link to the foxpro table,
but cannot get it to work as SQL Server returns an error message 'Could
not create an instance of OLE DB Provider 'CodeBase'.

I have been able to use the provider using ADO in VB 6.0, VC++ 6.0 and
VB.NET 2003, so surely I must be missing something, but am not sure
what it is.

Please could anyone give me a hand to either specify:
1) Each setting required on the Linked Server setup dialog,
or
2) The exact connection string and settings needed to make OPENROWSET()
work successfully.

Thanks in advance
Q.