Multi SQL connection - Forum - OpenEdge RDBMS - Progress Community
 Forum

Multi SQL connection

This question is not answered

In Duesseldorf EmeaPug 2014 Gus showed an existing but a little bit unknown feature to connect an auxiliary database with one sql connection. (or more than one)
I tried to get it working but have some troubles. I am missing any helpful information why the connection doesn't work. In the primary database log I get this:
[2014/11/26@16:41:02.274+0100] P-42436 T-59884 I SQLSRV2 2: (-----) User 63 Connection warning: Auxiliary databases not connected


That's in my [primary-db-name].oesql.properties:

[sql-configuration]
   configuration-names-list=winsext

[configuration.winsext]
   database-id-list=winsext

[database.winsext]
   Name=winsexr
   Catalog=winsext
   Location=C:\ProgramData\Progress\eNoraAcc\winsureuk\sure_db


Because the database is in the same directory I tried "." too, doesn't help.


I added "[-mdbq:winsext]" to the JDBC connection string and this is the only working thing in the moment.
When I change it to a wrong name I don't get the error message in the logfile.

Where I can check why the auxiliary database isn't connected?

All Replies
  • That's my first post with IE11, it is looking well formatted in the editor but then it looses all LF.

  • Specifying your OE version will be helpful

  • Use rich formatting and at the far right there is a button for inserting code.

    Consulting in Model-Based Development, Transformation, and Object-Oriented Best Practice  http://www.cintegrity.com

  • Indeed, 10.2B08 (32) on Windows 2008R2 (64)

  • Pressing "use rich formatting" first doesn't helps, still no LF in the preview.

  • Unfortunately, there is not much diagnostic information in 10.2B08. This issue is fixed in 11.3.3 and 11.5. In these versions, diagnostic info about failures during connection is written to a SQL_Connection log file

  • You need to use the code insert button at the far right on the second line of icons.

    Consulting in Model-Based Development, Transformation, and Object-Oriented Best Practice  http://www.cintegrity.com

  • I changed my original post with IE11 and compatibility mode.

    Perhaps it's easier to read know and somebody can help me?


  • On 11/26/2014 10:56 AM, Stefan Marquardt wrote:
    Thread created by Stefan Marquardt
    In Duesseldorf EmeaPug 2014 Gus showed an existing but a little bit unknown feature to connect an auxiliary database with one sql connection. (or more than one) I tried to get it working but have some troubles. I am missing any helpful information why the connection doesn't work. In the primary database log I get this: [2014/11/26@16:41:02.274+0100