Crystal XI VCL for Delphi 2006 - Foxpro report

[garyhoffmann]

Hello,

I have a report viewer program that a user has asked me to update to allow the display/printing of CR reports that use Foxpro databases via Foxpro ODBC.

This viewer is written in Delphi using CRXI Developer VCL.

When connecting and running a SQL Server based report, I use the following code:

Crpe1.Connect.ServerName := strDSNToUse;
Crpe1.Connect.UserID := OneReportUser;
Crpe1.Connect.Password := OneReportPass;

When connecting and running a Synergy ODBC report, I use the following code:

Crpe1.Connect.ServerName := strDSNToUse;
Crpe1.Connect.UserID := OneReportUser;
Crpe1.Connect.Password := OneReportPass;
Crpe1.Connect.DatabaseName := 'DBQ=' + OneReportConn;

(OneReportConn is a connection file which is like a leader to a database).

Does anyone know the parameters needed to connect to a foxpro database?

Thanks,
Gary.