Biometric HandReaders

PayPunch requires an instance of Microsoft SQL Server 2000 installed on one of your servers.

If you don't have a full version of Microsoft SQL Server 2000 already installed, you can download a free Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A from Microsoft website:

HTML Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A


INSTALLATION INSTRUCTIONS:

1. Download MSDE2000A.exe.

2. Run MSDE2000A.exe and unpack it into default folder (C:\MSDERelA).

3. Save this file (setup.ini) in the same folder (C:\MSDERelA) replacing the default one.

(You can edit this file later to change a default password for "sa" account from "sa" to another one.

4. Run "C:\MSDERelA\setup.exe" and follow the setup prompts.

5. After installing MSDE, please reboot your computer.

6. After rebooting, please verify that you can connect to your MSDE service via ODBC.

  • In Control Panel click on Administrative Tools - Data Sources (ODBC).

  • Click on "Add" button in "User DSN" tab.

  • Select "SQL Server" from the list and click "Finish".

  • Enter "test" as a name and description. Enter your computer name as a server name. Click "Next".

  • Choose "With SQL Server authentication...". Leave "Connect to SQL Server..." option checked. Specify "sa" as a "Login ID" and type in the default password ("sa").

  • Click "Next".

  • Leave all the options default and click "Next".

  • Leave all the options default and click "Finish".

  • In "ODBC Microsoft SQL Server Setup" window click on "Test Data Source" button.

  • If the connection is successful, click on OK to close "Test Results" window and click "OK" to finish.

  • You can remove this test ODBC connection. PayPunch will not need it at all. create User DSN connection.