We have an instance of MSDE sp3a with MDAC 2.7 that is linked to a Visual FoxPro database. We extract data through views with querys like:
Select * from openquery(linked_server,'Select fjobno, foperno form jodrtg')
This is working fine on all test platforms and in several production environments but suddenly stopped working on one installation where we get the error:
Could not create instance of OLE DB provider MSDASQL
Has anyone encountered this Any suggestions on causes Suggested corrective action
Could not create instance of OLE DB provider MSDASQL
umanwizard
Try the same connection string outside of the SQL Server using UDL file or VB script. See if it works.
Which OS do you use