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?
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.
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.
I changed my original post with IE11 and compatibility mode.
Perhaps it's easier to read know and somebody can help me?
Thread created by Stefan MarquardtIn 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[/collapse]