Difference between revisions of "Swansea"

Revision as of 12:49, 2 November 2015

Create a Blank IBID Database (IBID2)

Perform the following on UHSM-IBID2:

1) Download the 3 files from the Swansea section of the downloads on www.IBIDB.org into a folder called "Swansea" (or something equally as memorable)

2) Open Microsoft SQL Server Management Studio

3) Open the menu File -> Open -> File...

4) Navigate to the folder from step 1) and select the file called SWANSEA_IBID_38.25_DB.SQL

5) Click Execute on the toolbar

You're blank database, called Swansea is now created.

Point AquilaServer at the Swansea database (IBID1)

Perform the following on UHSM-IBID1:

1) Open the Notepad application (Start menu > All Programs > Accessories > Notepad)

2) File > Open

3) Change the drop down list from Text Documents (*.txt) to All Files

3) Go to the folder C:\Program Files\Evolution Healthcare Systems Limited\AquilaServer\

4) Open the file AquilaServer.INI.

5) Change the ConnectionString to point to the Swansea database by altering the name of the database (in bold), like this:

   [Settings]
   ConnectionType=MSSQL
   ConnectionString=AnyDAC?AuxDriver=MSSQL;Server=BLACKBOX;Database=SWANSEA;UserID=sa;Password=ehspass123;
   SessionTimeout=240