Hi Quinn,
Did you run DTS on WS or on the sqerver? If you're running it on WS, it runs localy and uses VFP OLE DB provider from WS not from the server. I would try to unregister and register vfpoledb.dll again on the server.
>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.
--sb--