Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with VFPOLEDB.1 in SQL Server
Message
From
27/02/2003 15:15:46
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Problem with VFPOLEDB.1 in SQL Server
Miscellaneous
Thread ID:
00759017
Message ID:
00759017
Views:
54
SELECT a.* FROM OPENROWSET('VFPOLEDB.1', 'd:\data\mydbc.dbc';;, 'SELECT * FROM mytable where type ="CM"') AS a

returned this error:

Server: Msg 7302, Level 16, State 1, Line 1
Could not create an instance of OLE DB provider 'VFPOLEDB.1'.
OLE DB error trace [Non-interface error: CoCreate of DSO for VFPOLEDB.1 returned 0x80040154].

This works:
SELECT a.*
FROM OPENROWSET('MSDASQL' ,
'DRIVER={Microsoft Visual FoxPro Driver};
Exclusive=No;Collate=Machine;Deleted=Yes;Null=No;
SourceDB=d:\data\mydbc.dbc;SourceType=DBC',
'SELECT * FROM d:\data\mytable where type = "CM" ') AS a

Please explain error message
Thanks
Anthony
Next
Reply
Map
View

Click here to load this message in the networking platform