Currently, the only way for a user to install Anywhere on a database (which will create the necessary tables, stored procs, etc.) is to run an Anywhere installer and specify a database.
Once Anywhere is installed against Database A:
- Remove Anywhere with Add/Remove Programs
- Re-install Anywhere against Database B
- Edit the Web.config file to add back the connection string to Database A
Now you should be able to choose from 2 databases in the Anywhere login.
Editing the Web.Config file
Add another connection string like:
<add name="Connection2" providerName="System.Data.SqlClient" connectionString="Server=localhost;DataBase=SBO_JCDemo2;User Id=sa;password=sa" />
Web.config can be found on the server under: C:\Program Files (x86)\Eralis Software\Anywhere\Anywhere
In this example, Anywhere is installed against 2 schemas; JCDemoEA & JCDemo
Article is closed for comments.