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

Asked By Christina J Smith 20 points N/A Posted on - 11/23/2012

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.

• Status: Open
• Question Views: 1231
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: FoxPro

Best Answer by Jeremy J McPhail

Go To Solution

Answered By Mohammad M Hartz 0 points N/A #129675

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

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.

About Mohammad M Hartz

Questions
9

Answers
9

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 03/12/2013
• Question Category: FoxPro

Best Answer

Best Answer

Answered By Jeremy J McPhail 50 points N/A #129676

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

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!

About Jeremy J McPhail

Questions
10

Answers
106

Best Answers
39

• Vote Up 0 Vote Down

• Posted on - 03/13/2013
• Question Category: FoxPro