FTDP MSSQL Installation

Thursday, February 02, 2012 FingerTec 11 Comments

The MSSQL database server records all user information and transactions. The high storage capabilities of the server eliminates the need for a conventional filing system, providing a better and paperless working environment. It is possible to install FTDP to work with MSSQL so that a 3rd party software plug-in can access the transaction data with ease.

How to install FTDP MSSQL:

1. Install FTDP > Go to Control Panel > Click on Administrative Tool > Click Data Sources (ODBC) > At the User DSN tab, click Add and select SQL Server > Click Finish.

2. Insert Name "FTDPSQL", select a MSSQL server, click Next.


3. Input MSSQL login information, click Next.


4. Check the database information and click Next.

5. Check the server and database information and click Finish.

6. Click the Test Data Source to make the connection to MSSQL is successful.

7. Go to Start -> Programs -> FingerTec -> FingerTec Data Processor -> Init MSSQL Database. 

8. Input the server name, server username and server password. After that click Connect.

9. After you are connected to server, click Initialize to start init MSSQL database.

10. Click Disconnect to complete the initialize process.

11. Open FingerTec Data Process, go to Configuration -> Database Setting.

12. Click on the Provider Tab, select Microsoft OLE DB Provider for SQL server -> Next.

13. In the Select or enter a server name, select the PC where the SQL server is installed.
 
14. Enter the Username & password, tick Allow Saving Password, and test the connection.

(User needs to connect the SQL server by using SQL server authentication.)



14. Restart FTDP, and voila! You're done.

Refer below for the simple FTDP table description:

TRANSACTION

LID - table unique ID
UserID - user id in clock
TemID - terminal id in table terminal
DateTime - date & time of the log
InOut - check-in (0) or check-out (1) value of the log
Workcode - work code of the log
VerMode - verification mode (0-fp, 1-password)

USERS

ID - table unique ID
UserID - user id in clock
UserName - user name in clock
Password - password in clock
Privilege - privilege value in clock (refer to privilege table)
CardNo - user's card number in clock
Name - user full name
VerType - user verification type in clock
Valid - Is user valid (enable/disable) in clock
RegDate - the date of user downlaoded from clock
TplCount - user template count in clock
TZGID - user time zone group ID (refer to table TZG)
Slct - is selected (for check/uncheck user on the screen)
FaceCount - user face template count (0/1)

TEMPLATE

ID - table unique ID
UserID - user id in clock
Index - template index number
Tpl - template data
EnDate - enrollment date (reserve value)
TplType - template type, fingerprint algo 9 or 10

Written by Aidid, Edited by Vincent

11 comments:

  1. Hi,

    I have SQL Server 2012 and when I try to click Initialize, it shows an error like below :

    =============
    Failed:EOleException-The CREATE DATABASE statement failed. The primary file must be at least 5 MB to accommodate a copy of the model database
    =============

    can you help please ?

    ,, Regards

    ReplyDelete
    Replies
    1. Hi Sir,

      Please re-install the FTDP with the latest setup file and check whether still getting the error message or not.

      You can download the latest setup file at http://www.mediafire.com/?xz0v7yjg6d5zzpn

      If still getting the error message, kindly arrange team viewer session for us to do the remote checking. You can refer at http://www.fingertec.com/teamviewer/FT_teamviewer.html for your reference.

      Delete
  2. Finally, after so much effort in trying to get this shit to work, I got it. Gee, this makes work so much better.

    ReplyDelete
    Replies
    1. It's our pleasure. Make sure to contact us if you need any assistance. Thank you and have a nice day.

      Delete
  3. Hi ,
    we have configured the system on default database i.e is on access. Now we want to configure it to sql database. can you provide the steps for the same.

    ReplyDelete
    Replies
    1. Hi Jaya Prakash,

      Kindly please provide us your email address so our programmer can assist you better. Otherwise you can email to us at support@fingertec.com about your query.
      Thanks

      Delete
    2. Thanks Sharul, I have emailed the details to support@fingertec.com

      Delete
  4. Hi

    Can the FTDP software be used in conjunction with Ingress?

    ReplyDelete
  5. Hello Anonymous,
    No, Ingress cannot work directly with FTDP, like TCMS. However you can use FTDP and Ingress independently, as both of them can be configured not to delete transaction logs from the device.

    ReplyDelete
    Replies
    1. So, can Ingress and FTDP can work in parallel but have access to the same database of personnel & logs?

      Delete
    2. Dear Customer,
      As mention earlier, you can installed the Ingress software and FTDP in parallel but you cannot access the personnel or logs it in the same database.

      Delete

Have any questions or inquiries about FingerTec? Drop your input here.