Multiple Database 10.2b - Forum - DataDirect Connect - Progress Community
 Forum

Multiple Database 10.2b

  • hello everyone, I followed the tutorial and it did not work;

    http://knowledgebase.progress.com/articles/Article/3409

    Directory/File :

    File (edited);

    RUN(execute);

     

    Anyone know what error,

     

    Tanks,

     

    Alexandre

  • Hi Alexandre,

    Actually, the sample worked that way you configured it to work, but not perhaps as you wanted it to work.

    Your syntax error from the last screen snapshot is correct, because the proper syntax is:

    SHOW CATALOGS ALL

    Now, if you wanted to connect multiple databases, then you should have configured your oesql.properties differently.

    Here is the example taken directly from the documentation "OpenEdge® Data Management: SQL Development" page 171 :

    [sql-configuration]

      configuration-names-list=NortheastSales, ALBSales

    [configuration.NortheastSales]

      database-id-list=MA, NH

    [database.MA]

      Name=Mass

      Catalog=Mass

      Location=/usr1/kjain/States/Mass

    [database.NH]

      Name=NewHampshire

      Catalog=NH

      Location=/usr1/kjain/States/NewHamp

    [configuration.ALBSales]

      database-id-list=Ny, Ma1

    [database.Ny]

      Name= NewYork

      Catalog=Lions

      Location=/usr1/kjain/States/NewYork

    [database.Ma1]

      Name= Mass

      Catalog=Bears

      Location=/usr1/kjain/States/Mass

    Hope this helps...

    ______________________________________________________
    There is a time to laugh and a time not to laugh, and this is not one of them.

  • Sorry, wrong print screen select ,

     

    Tnks

  • Hi Alexandre,

    I still don't see where is the error in your last post.

    What are you trying to achieve ?

    Have you tried configuration as I suggested in my previous post ?

    ______________________________________________________
    There is a time to laugh and a time not to laugh, and this is not one of them.

  • Working!! Thanks for your help and patience Sasha !

    Cya.

     

  • Morning,

    ODBC has SUCESS on test,

    On execute SQL, show me this error,

    SELECT "denominacao","nat-operacao","emite-duplic","tipo" FROM PUB."natur-oper" WITH(NOLOCK)

    Why ?

    Tnks