Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Data Access and SQLDirect

edited March 2004 in End User
I'm using Report Builder 6.02 enterprise with Delphi 5. In my application,
I've changed BDE to SQL Direct. I'm using a report explorer to make the
reports, but I have no suport for SQL Direct access via RB. How can I do
that? Is that an example of making a component for supporting SQL Direct?
Also, I need that the db connection is fixed and it cannot be changed, so I
want the user to build the query, but not changing the connection. Can it be
done in BDE too??
Thanks

Daniel Alvarez
IMS Soluciones Tecnol?gicas S.A.
www.kropol.com

Comments

  • edited March 2004

    To use SQLDirect with the ReportBuilder Query tools will require a DADE
    plug-in. The following web page lists the available DADE plug-ins. It does
    not appear that one is available for SQLDirect. You could either create one
    or contact the publishers of SQLDirect and request that they create one. See
    the DADE thread of the Tech Tips newsgroup for an overview of the
    architecture. Creating a DADE plug-in is most easily accomplished by using
    of the existing DADE plug-ins as a starting point and then changing the
    class names and any implementation details.

    http://www.digital-metaphors.com/Subpages/Downloads/companionproductsDadePlugins.html



    --
    Nard Moseley
    Digital Metaphors Corporation
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited March 2004

    To define a fixed connection for BDE, place a TDatabase component on the
    EndUser form and configure the connection parameters. Then set the
    Designer.DataSettings.DatabaseName to point to the TDatabase component.




    --
    Nard Moseley
    Digital Metaphors Corporation
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited March 2004
    Thank you very much.... I looked in SQL Direct page and there is a DADE
    plug-in developed by them to download.

    Daniel


  • edited March 2004
    Thanks

This discussion has been closed.