Run querys on different database with Progress

• sandra ximena monroy

  Grasshopper

  Points: 13

  More actions

  August 5, 2013 at 4:43 pm

  #296469

  Hi guys,

  I am using ODBC to connect Progress from Sql server 2008, But I need to connect with two differents databases on the same query, It is possible?

  I am using Progress OpenEdge 11.2

  Any help would be greatly appreciated.

  Thanks,

  Sandra

• WolfgangE

  SSCertifiable

  Points: 6328

  More actions

  August 9, 2013 at 1:11 pm

  #1640254

  Actually it does not really matter on which database you connect initially.

  When referencing tables (or any other database objects) you can youse a 3-part-name where the first part defines the database of the object.

  select * from Database1.dbo.Table1

  select * from Database2.dbo.Table1