Table of Contents

, , , ,

BioStar V1.8 Server Matching

Unfortunately, BioStar V1.8 has a bug with “Server Matching” module, and it is required to apply patch. In this document, we would like to introduce how to apply Server Matching patch for BioStar V1.8. There are three different ways to apply patch based on the database you are currently using. Please kindly check your database type and follow the instructions.

MSSQL

  1. Open SQL Server Management Studio Express. If you do not have this program, you can download it from Microsoft Download Center.
  2. Click New Query button and execute the following query;
USE BioStar
GO
 
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[sp_SelectAllUserFingerPrintInfo]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[sp_SelectAllUserFingerPrintInfo]
GO
 
CREATE           PROCEDURE dbo.sp_SelectAllUserFingerPrintInfo
WITH encryption
AS
       SET nocount ON
 
SELECT nUserIdn, nIndex, bTemplate, nTemplatecs, nDuress, nEncryption, nSecurityLevel, nFingerIndex, nTemplateIndex
FROM TB_USER_TEMPLATE
ORDER BY nUserIdn, nIndex, nTemplateIndex
 
GO

MySQL

  1. Go to C:\Program Files\BioStar\server. (If you are using 64bit computer, go to C:\Program Files(x86)\BioStar\server.
  2. Copy and paste the mysqlUserManager.dll to this folder.

Oracle

  1. Go to C:\Program Files\BioStar\server. (If you are using 64bit computer, go to C:\Program Files(x86)\BioStar\server.
  2. Copy and paste the oracleUserManager.dll to this folder.