If you are using an Oracle Database then it is just as simple as the above configuration for MSSQL. Start by connecting to your database engine as shown below:
You would then have to create a user called ‘Core’ with the script below and also shown.
CREATE USER CORE IDENTIFIED BY {Type your password here}
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP";
Carry on by ‘Granting’ “DBA” role to “CORE” user with the script below also shown:
GRANT "DBA" TO CORE;
Then connect to your database with the ‘CORE’ user:
Run the database creation script:
Open the configuration file which is at ‘WebsitePhysicalPath\IDscanEnterpriseSvc\Web.Config’ or for example shown below:
Find the nodes below and write your connection string to “value” attribute in “DBConnectionString” node.
<add key="DBConnectionString"value="DataSource=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST={HostAddress})(PORT={PortNumber}))(CONNECT_DATA=(SID={DatabaseName})));
User Id={Username};Password={PWD}" /> <add key="DBProvider" value="Oracle" />