eMaRC Plus comes preconfigured with some default settings so that the program can be run immediately after installation. However, before putting this program in production use you should look at the program configuration and make changes to suit your environment/preferences.
The configurations are set in the Configuration dialog, which can be accessed from the System Configuration menu item under the Administration menu. The following options can be set:
1. Database Type: Select the database type from the drop down list. Your choices are MS Access, MS SQL Server, Sybase Anywhere, and Oracle.
2. Pathology Reports Database Connection String: OLEDB connection string to the Pathology Reports database. This is the main database that will store imported messages and parsed data values from messages. This database also contains the DATAMAP table, lookup tables, translation tables and other parameter tables. The default value is pointing to an Access database, Pathlab.mdb, which is included with the install. eMaRC Plus uses the database-specific OLEDB library to connect to the database. You should refer to your database management system’s resources to find the OLEDB connection string. Following are some samples of connection strings for different database management systems.
MS SQL Server: PROVIDER=SQLOLEDB;SERVER=servername;DATABASE=pathdb;UID=pathdb;PWD=****;
Oracle: Data Source=XE;User Id=phinuser;Password=*****;
MS Access: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\mapperplus\pathlab.mdb;User Id=admin;Password=;Mode=Share Deny None;
SQL Anywhere: Data Source=Pathlab;UID=DBA;PWD=***
Important: This install package contains pathlab.mdb which is the starter Microsoft Access database to store pathology data and the application, by default, is configured to use this database. To create initial database objects in other database management systems SQL scripts are included under the [Application Folder]\dbscripts folder. You may also have received email notification on where to get the most up to date database scripts to create initial databases in different database systems.
Also note that client connectivity libraries may need to be installed if you are using database management systems other than MS Access or MS SQL Server. The client libraries for MS Access, and MS SQL Server are part of the standard .NET Framework, therefore no additional tools/libraries are required.
|
