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