Multiple db's on the same computer (V 1.3)

This is a good theory, but unfortunately RMS stores its settings in the HKEY_Local_Machine registry key so there is only one set per machine. I also believe the RMS installer package will not allow to have multiple instances. Sorry Joe, but as far as I am aware you are out of luck.

You need to have a "login" screen before open RMS, to change the database settings in registry.

cod

What I've done for this is to set all the configurations for one of the databases, then export the registry key and have it sitting on the desktop, renamed appropriately. Then do the same thing for the other database which will leave you with two shortcuts on the desktop and when each is dbl-clicked will import the proper connection info into the registry, subsequent access to Manager / POS will take you into the proper instance of RMS...

Hope this help, Todd NitroSell

I have a script file ( I think I got the idea from this group, if not the code itself) that acts as a database chooser.

I saved the registry exports Todd recommends then used a batch file to prompt the user to pick a database. The batch file changes the necessary registry settings, launches Store Ops Mgr and closes the batch file.

Settings are permanent until changed.

Tom

Joe: I have done this very thing to have a training database and a production database. First you need to create two databases on your server, one for production and one for training. Then you need to create two VB Script files to modify your registry settings and then launch POS. The VB Script file should look like this:

' Begin code for production.vbs ' Written by Ted Archer ' Version: 1.0 (February 25, 2004)

Option Explicit

Dim WSHShell, RegKey, RegKey2

Set WSHShell = CreateObject("Wscript.Shell")

RegKey = "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Operations\Server\Database\" RegKey2 = "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Operations\POSUser\Register\"

WSHShell.RegWrite regkey & "Provider", "SQLOLEDB.1" WSHShell.RegWrite regkey & "Persist Security Info", "True" WSHShell.RegWrite regkey & "User ID", "sa" 'Enter the SQL User Name here WSHShell.RegWrite regkey & "Password", "%TUOY" 'Enter the SQL Server Password here WSHShell.RegWrite regkey & "Data Source", "SQLSERVER" 'Enter the name of your SQL Server here WSHShell.RegWrite regkey & "Connect Timeout", "45" WSHShell.RegWrite regkey & "Initial Catalog", "PRODUCTION" 'Enter the Database name here

WSHShell.RegWrite regkey2 & "Number", "1"

WSHShell.Run("soposuser.exe")

' End code

Modify the code to use your SQL User Name, SQL Server Password, SQL Server Name and SQL Database Name. The password is stored in the Registry in an encripted format. You can open the registry, go the the key and cut and paste the value into the script. The above value is for a blank password.

Create a second script, training.vbs and place both scripts in the \Program Files\Microsoft Retail Management System\Store Operations folder. Then create a shortcut to the scripts on your desktop.

When you double click the shortcuts, the script will modify the registry (the same as if you had opened SO Administrator) and then launch POS. The POS will stay connected to the current database until you use the other shortcut or open SO Administrator and change the values.

I have created a false item in my training database that appears first in the Item List so that if I am unsure, all I have to do is press F2 and view the list to know which database I am attached to.

Good luck, Ted Archer Fairvilla Megastore

Thanks Ted and I am anxious to try this, however, I do not understand how to run a VB script?? I only know how to do SQL statements.

Is the following info the way to do the VB script? If so, the part I don't get is where I would go in the registry to which key to cut and paste password.

Really appreciate....thanks alot

Modify the code to use your SQL User Name, SQL Server Password, SQL Server

"Ted Archer" wrote: