Home Forums SQL Server 2005 SQL Server Express How to connect SQL SERVER 2012 EXPRESS ADVANCEd to a PROGRESS database ? RE: How to connect SQL SERVER 2012 EXPRESS ADVANCEd to a PROGRESS database ?

  • June 25, 2013 at 10:31 am

    #1627225

    Lidou123 (6/25/2013)

    Hi Lowell,

    Thank u for your answer.

    I tried to connect via linked server and that wooooorks !!!!!!!!!!!!!!! 🙂

    Thank U.

    So, now I can create a report and deploy it ??

    Or I must to do something else ??

    Lidou 123

    awesome, glad it's working for you!

    now it's up to you and how up-to-date the data needs to be.

    for a report, does the report REALLY need up to the second data, or can it be a little behind?

    linked servers are notoriously slow, and you can also run into permissions issues, depending on how you set up the linked server.

    i personally prefer to grab the data from a linked server at intervals with a scheduled job, and let my reports read the slightly-out-of-date-but-orders-of-magnitude-faster local data.

    so my process might grab data a couple of times a day for reports, and any SSRS reports just hit a local table on my server with the data i grabbed from some remote linked servers.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!