On Tue, 20 Jun 2006 17:20:14 -0400, "Erik Zimmerman" <erikz@compadmin.com> wrote:

Eric,
We have traditionally used Crystal Reoprts as a stand alone product to report from P.SQL tables via its own P.SQL driver. Recently, we changed to
using ODBC and there was a noticeable increase in speed. We do have a fairly highly spec'd server. The existence of DSN's has no effect at all on
VDF or it's tools.

Ian Vagg

>Hi.
>
>We are evaluating P.SQL9. (with VDF 11.0). And looking for some guidance.
>
>We expect to use the Dataflex Connectivity kit for most database activity
>(data entry views etc...). We are considering using ODBC/ESQL for reporting
>and/or batch processes. Would there be speed gains in using Embedded SQL in
>a batch process? Most reporting is done in WinPrint and basic report, but
>we are not ruling out crystal at this point.
>
>I am familiar with the meta-data tables (DDFs), however I'm interested in
>learning about creating a DSN how and does this affect using the VDF tools
>i.e. DbBuilder?
>
>Does anyone have any experience/suggestions/recommendations?
>
>Thanks in advance.
>
>Erik
>
>