Working with multiple companies

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:

1. Remove Anywhere with Add/Remove Programs
2. Re-install Anywhere against Database B
3. 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