Post reply

How connect several progress databases with one sql linq connection.

  • September 20, 2011 at 6:02 am

    #248165

    Hi There,

    Could you please help me I need to connect several progress database with one sql link connection in sql 2005?

  • September 20, 2011 at 6:06 am

    #1383770

    this link shows how to make a linked server to a PROGRESS database:

    http://progress.atgnow.com/esprogress/jsp/AnswerControls.jsp?directSolutionLink=1&tabs=true&docPropValue=p120484

    from there, it's a matter of the linked server calls via 4 part naming conventions:

    select * from lsProgress..Database1.Table1

    select * from lsProgress..Database2.Table2

    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!

  • September 20, 2011 at 8:46 am

    #1383889

    Are you running 32 or 64 bit?

    We create a system-level ODBC on the server (using the appropriate driver of course - in our case it's the DATADIRECT 4.0 32-bit Progress SQL92 v9.1E), then create a linked server to it. This for the most part works well. However this will be limiting to one DB per ODBC connection...

    IMHO it's better to send the query off to progress and allow it to execute over there in la-la land than have SQL Server do it. In the past I've experience degraded performance when running queries to Progress using the 4-part naming convention...

    Then as Lowell suggested, you can use multiple selects from the different linked servers and throw in a UNION to combine your results from the multiple servers.

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply