Foxpro drivers for XI

[Former Member]

Hi

We have a requirement to extract/write the data from/to Foxpro System using XI.

Can anyone suggest how to approach this?

JDBC Drivers for Foxpro?

XI Supported with Foxpro?

Thanks in advance.

Regards

Chandu

[prateek]

FoxPro communication could be done using JDBC connection.

Check for Microsoft FoxPro VFP Driver for DBF. Instead of ODBC you may need to use OLEDB UDS.

Regards,

Prateek

[Former Member]

Hi Prateek,

Thanks for the prompt response.

Can you please elaborate on the usage of OLEDB UDS? Is there any "how to guide"?

How to deploy Microsoft FoxPro VFP Driver for DBF?

Regards

Chandu

[prateek]

Check this for OLEDB UDS

http://help.sap.com/saphelp_xmii115/helpdata/en/Connectors/Universal_Data_Servers/OLEDB_UDS_User_s_G...

For driver installation

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

Regards,

Prateek

[Former Member]

Thanks very much Prateek. We will review this in the coming days and award full points accordingly.

I believe the document you referred to JDBC adapter is for Oracle & SQL Server, but applicable to Foxpro. We already have JDBC drivers for Oracle & SQL Server in XI, so we will add this driver to the existing aii*.sda file and try.

Final question, have you implemented this for Foxpro? Any idea about SAP's position/certification with regards to Foxpro.

Regards

Chandu

[prateek]

I have not implemented it yet. But came across a similar requirement once for a POC.

There doesn't exist any certification in this regard. (AFAIK)

Regards,

Prateek