Hi all,

I'm trying to setup auxiliary databases when using SQL client, but I'm stuck.

I tried this simple test :

Two different databases living in the same directory, started with :

proserve db1 -N TCP -H hostname -S 12000

proserve db2 -N TCP -H hostname -S 12001

In this directory, I created two files db1.oesql.properties and db2.oesql.properties with the same content :

[sql-configuration]
     configuration-names-list=CFG
[configuration.CFG]
       database-id-list=C,G
[database.C]
       Name=db1
       Catalog=Aux1
       Location=C:\Users\gquerret\db\db1

[database.G]
       Name=db2
       Catalog=Aux2
       Location=C:\Users\gquerret\db\db2

I'm connecting to those databases using SquirrelSQL. No problem connecting to both databases, I see the schema of the main database, but I never see the additional catalogs.

Every time I connect a database, there's this message in .lg file :

[2010/06/07@14:48:23.729+0200] P-4404       T-1120  I SQLSRV2 1: (-----) User 24 Connection warning: Auxiliary databases not connected

Security is identical on both databases (same username/password).

Executing

CONNECT 'db2' AS CATALOG Aux2

from the first DB is working.

Does anybody know what I'm doing wrong ? Or how to have additional debug informations ?

10.1C04, Win32

Gilles