I faced a problem with my FoxPro database trace when I tried to open an ODBC connection as it keeps returning an error. Error says, Server Error which occurred while retrieving the list of Databases from & the server returned a non-specific error.
First of all you check ODBC Drivers installed for Fox pro to server and also on the system you running with SharePoint.
So you check ODBC connection string for Fox pro database if fiddler retrace the following Error OLE DB provider you are looking to utilize has not been enabled by the site administrator.
Hello, Christina
Hope you are fine.
Let me first know that have you installed ODBC Driver for FoxPro on your Sharepoint servers and on the computer in which you operate SharePoint Designer or not?
An ODBC connection to a FoxPro can be created by taking fiddler trace when you attempt to create it.
Now check if the fiddler trace shows the error saying that the OLE DB provider is disabled by the site administrator which you are trying to use.
If it does,run the command on the SharePoint server given below:
"stsadm -o setproperty -pn data-retrieval-services-oledb-providers -pv DB2OLEDB; IBMDADB2; MSDAORA; OraOLEDB.Oralce; SQLOLEDB"
Hope this will solve your problem.
Best of luck!
