Results 1 to 7 of 7

Thread: Moving from embedded DB to MS SQL

  1. #1
    Join Date
    Feb 2009
    Location
    Denmark
    Posts
    335

    Default Moving from embedded DB to MS SQL

    For the first time in my life :-o I am going to have one of my applications run using MS SQL. With a little help I installed SQL Express and made the conversion of the embedded DataFlex database (Thank you, Klaus). However, now I have this large number of Crystal Reports pointing to DataFlex tables. 3 questions:


    1. When opening a report, I see no places where I can connect to the MS SQL database. What do I do? Do I need to install som drivers or configure something i Crystal?
    2. Is it possible in the DataFlex application to redirect the report to the MS SQL database? (Today I use the Knowledge Base article 1330 to redirect all subreports to the customer’s data directory).
    3. Does MassVerify still work, and where can I test and buy it?


    I’m using DF 18.2 and SQL Express 2016 SP2.
    Jørgen Münster
    Senior Analyst Programmer
    Dialog Consult
    Denmark

  2. #2
    Join Date
    Feb 2009
    Location
    Somewhere in Vermont, USA - unless I'm not
    Posts
    11,085

    Default Re: Moving from embedded DB to MS SQL

    Mass verify is no longer available I'm afraid.

    In CR, choose Create New Connection, then OLE DB (ADO), then your SQL Server Native Client (11 on the one I just looked at) & then follow through the wizard, choosing your DB & whatever security you are using, etc.
    Garret

    Time for an oldie but goodie:

    "If it ain't broke, you're not trying." - Red Green

  3. #3
    Join Date
    Feb 2009
    Location
    Adelaide, South Australia
    Posts
    2,863

    Default Re: Moving from embedded DB to MS SQL

    Hi Jorgen
    Once you have nailed down the keystrokes for a crystal to be converted, use a program like autohotkey to repeat these keystrokes for each crystal report while you are having a nap.
    Cheers
    Marco
    Marco Kuipers
    DataFlex Consultant
    28 IT Pty Ltd - DataFlex Specialist Consultancy
    DataFlex Channel Partner for Australia and Pacific region
    Adelaide, South Australia
    www.28it.com.au

  4. #4
    Join Date
    Feb 2009
    Location
    Denmark
    Posts
    335

    Default Re: Moving from embedded DB to MS SQL

    Thank you, Garret. I got it.
    Jørgen Münster
    Senior Analyst Programmer
    Dialog Consult
    Denmark

  5. #5
    Join Date
    Feb 2009
    Location
    Denmark
    Posts
    335

    Default Re: Moving from embedded DB to MS SQL

    I will consider that. Until now I have only used AutoHotkey when editing sheet music. ;-)
    Jørgen Münster
    Senior Analyst Programmer
    Dialog Consult
    Denmark

  6. #6

    Default Re: Moving from embedded DB to MS SQL

    MassVerify has been dead for years, but there's RptVerify:

    https://dataflex.wiki/index.php/Port...l_Report_Tools

    (sorry for posting a dataflex.wiki link that points back to the forum )

    --
    Wil

  7. #7
    Join Date
    Feb 2009
    Location
    Somewhere in Vermont, USA - unless I'm not
    Posts
    11,085

    Default Re: Moving from embedded DB to MS SQL

    I hadn't remembered that Mark had released his tool - it works even better than MV did.
    Garret

    Time for an oldie but goodie:

    "If it ain't broke, you're not trying." - Red Green

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •