ODBC Database
ODBC can be use to create a direct connection to your database without using Microsoft Access as a pass through.
Select your DSN from the drop-down menu that you created using the ODBC Data Source Administrator.
Enter the wildcard character used by your RDMS (Relational Database Management System).
Name of the table in your database that will be used to store the data for the badges.
Name used to access your database, the same one entered when creating the DSN.
Password used to access your database, the same one entered when creating the DSN.
Opens the ODBC Data Source Administrator from within IDpack.
Test your DSN connection to your database.
Certain fields need to be added to the main table used by IDpack.
idp_insertdate - this field is required to store the date and time a new badge is added.
idp_moddate - this field is required to store the date and time a badge has been edited.
Certain fields need to be added to the main table used by IDpack if selected options are used.
Idp_barcode is required when the option "Put date/time in database when using QuickFind" from the producer setup tab is used.
Idp_picture is required when the option "Put date/time in database when taking picture" from the producer setup tab is used.
 Note
IDP_Stats table will be required when Enable Activity Log is selected in Producer Setup tab. See IDpack Database Structure for details
|
