We have a challenge that our DSN's and Database Names change often and we want to provide redundancy for that.
We see we can configure Pervasive Engines to point to DBNAMES.CFG on a Netware 6.5sp7 clustered volume. We have that engine configuration option pointed succesffuly to the file copied into a folder we created named VOL1:\PVSW\BIN, and it works great.
But....
Redundancy is incomplete if we can not also put ODBC.INI on the same shared cluster volume.
We have tried many options to place ODBC.INI on the shared cluster volume VOL1: and changed MGRSTART.NCF to point to ODBC.INI placed in our manually created VOL1:\ODBC redundant location. No matter what we do NWSQLMGR.NLM compalins it can't find the database names file when it loads. Even when we just move this one file. The location named in that load line is valid and VOL1 is mounted before the load attempt.
This works (stock): load nwsqlmgr sys:\odbc\odbc.ini
This does not (desired) : load nwsqlmgr vol1:\odbc\odbc.ini
Seems easy and logical. Doesn't work. How can we convince NWSQLMGR.NLM to load using ODBC.INI on a volume other than SYS:? Without that we do not have full database names/dsn real-time redundancy. And it gets a little ugly keeping dbnames.cfg and odbc.ini in sync. Many thanks, Jim