General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Vfpoledb.1 problems
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only