I am trying to do a select from a FoxPro table to a SQL database. I am following the example in last months UT magazine.

select a.* from openrowset('VFPOLEDB.1','i:\lis\data';;,'SELECT * from sis') as a

I also tried:

select a.* from openrowset('VFPOLEDB.1','Data Source=i:\lis\data;
Mode=Share Deny None;Extended Properties=""; UserID="";Password="";Mask Password=False;
Cache Authentication=False;
Encrypt Password=False;Collating Sequence=MACHINE',
'Select * from sis') as a

I keep getting the error:
Could not create an instance of OLE DB provider 'VFPOLEDB.1'.

I am able to do DTS sunctions of the same table with the same driver. The vfpoledb.dll file is registered on the server in the c:\program files\common files\system\ole db

Thanks in advance.