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

ODBC Express or NativeDB

edited March 2003 in End User
how can I port from BDE to ODBC Express (or NativeDB). I know that I can use
from the developer standpoint but how to allow the user to select from those
tables if there is no BDE "database" to connect to.

thanks,
Luis

Comments

  • edited March 2003
    The BDE and ODBC are just connectivity options you can use to get at the
    database. You'll have to create a new end user report solution using
    different data access components (BDE to ODBC Express components). There is
    an ODBC Express DADE plugin available from our website in our Friends | Data
    section. The main problem is converting your user's templates. The templates
    save dataview definitions down, ie. the classes in the BDE plugin you've
    used: daDBBDE.pas. The solution is to create a new dataview and save it as
    ascii text using the DBExpress plugin in a new report. Then compare this to
    a BDE based report template on the same database and table/fields. You
    should see that the class names are different for the query dataview
    classes. You'll have to create a text converter to load the report templates
    from a BLOB field or file into a stringlist, make you changes to convert the
    BDE DADE plugin class names to the DBExpress DADE plugin class names. Then
    save the template back down and try to load it into the new DBExpress report
    project. Here is an example of loading a binary template as ascii text into
    a string list and saving it back down as a binary template.

    http://www.digital-metaphors.com/tips/ConvertBinaryTemplateToASCII.zip

    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited March 2003
    Sorry, I said DBExpress a couple times in my post, I meant ODBCExpress:)


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited March 2003
    "Luis" wrote in message news:3e6fa9e5$1@dm500....
    use
    those
    NativeDB have a package that performs this function. Go to the download
    section of their site.
    Jon
This discussion has been closed.