Connection error while using a FoxPro database to trace with ODBC connection

Asked By 20 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by Jeremy J McPhail
Answered By 0 points N/A #129675

Connection error while using a FoxPro database to trace with ODBC connection

qa-featured

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.

Best Answer
Best Answer
Answered By 50 points N/A #129676

Connection error while using a FoxPro database to trace with ODBC connection

qa-featured

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!

Login/Register to Answer

Related Questions