便用OpenDataSource出現錯誤信息Could not locate registry entry for OLE DB provider ...如何處理?

Question

SELECT * FROM OpenDataSource('VFPOLEDB','Data Source="c:\temp"')...temp
文件C:\temptemp.dbf是存在的

Answer 1

try:SELECT * FROM OpenDataSource('VFPOLEDB.1','Data Source="c:\temp"')...temp

Answer 2

執行後還是出現相同的錯誤信息,
Server: Msg 7403, Level 16, State 1, Line 1
Could not locate registry entry for OLE DB provider 'VFPOLEDB.1'.在注冊表中找到了VFPOLEDB的注冊信息Windows Registry Editor Version 5.00[HKEY_CLASSES_ROOT\CLSID\{50BAEED9-ED25-11D2-B97B-000000000000}]
"OLEDB_SERVICES"=dword:ffffffff
@="VFPOLEDB"[HKEY_CLASSES_ROOT\CLSID\{50BAEED9-ED25-11D2-B97B-000000000000}\ExtendedErrors]
@="Extended Error Service"[HKEY_CLASSES_ROOT\CLSID\{50BAEED9-ED25-11D2-B97B-000000000000}\ExtendedErrors\{50BAEEDA-ED25-11D2-B97B-000000000000}]
@="VFPOLEDB Error Lookup"[HKEY_CLASSES_ROOT\CLSID\{50BAEED9-ED25-11D2-B97B-000000000000}\Implemented Categories][HKEY_CLASSES_ROOT\CLSID\{50BAEED9-ED25-11D2-B97B-000000000000}\Implemented Categories\{D267E19A-0B97-11D2-BB1C-00C04FC9B532}]
@=""[HKEY_CLASSES_ROOT\CLSID\{50BAEED9-ED25-11D2-B97B-000000000000}\InprocServer32]
"ThreadingModel"="Both"
@="E:\\Program Files\\Common Files\\System\\ole db\\vfpoledb.dll"[HKEY_CLASSES_ROOT\CLSID\{50BAEED9-ED25-11D2-B97B-000000000000}\OLE DB Provider]
@="Microsoft OLE DB Provider for Visual FoxPro"[HKEY_CLASSES_ROOT\CLSID\{50BAEED9-ED25-11D2-B97B-000000000000}\ProgID]
@="VFPOLEDB.1"[HKEY_CLASSES_ROOT\CLSID\{50BAEED9-ED25-11D2-B97B-000000000000}\TypeLib]
@="{50BAEECA-ED25-11D2-B97B-000000000000}"[HKEY_CLASSES_ROOT\CLSID\{50BAEED9-ED25-11D2-B97B-000000000000}\VersionIndependentProgID]
@="VFPOLEDB"