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).
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 ?