Tag Archives: Asure Software

Asure ID 2009 Software – Using SQL as the Native Database

Setting up Asure 2009 to use SQL as the Native database:

The first thing that needs to be done is have the SQL Database Administrator create a database instance for Asure 2009 to use. The security setting for the database needs to be set by the SQL Database Administrator. They need to grant full read/write privileges to the database instance.

On that instance the SQL Database Administrator needs to run the table creation script. The script can be found at the location shown in the following screen shot:

Once the script has been run to create the tables Asure 2009 can now be connected to the database. Under the start menu, choose the “Data Connection Wizard” as shown below:

This will start the wizard to connect Asure 2009 to the SQL Database.

Below is the first screen for the wizard:

Click next to continue setting up the customer database configuration for Asure 2009.

The next screenshot is the wizard asking what type of custom database Asure 2009 will be connected to:

In this example choose “Microsoft SQL Server” and click “Next”.

The following screen shot is the actual set up screen of the wizard. This is the general data connect window for SQL Server:

Under “Server Name” the name of the SQL Server needs to be entered. Then under “Initial Catalog” type in the name of the Database Instance that the SQL Database Administrator set up for Asure 2009 to use. The “User Name and Password” should be provided to you by your SQL Database Admin. These can either be specified user names and passwords or it can be set up to “Use Integrated Security”. This means that who ever logged on to the computer has access to the database.

Once it is all filled out, click “Next”.

The wizard is now complete.

You can click the “Test” button to test the connection to the SQL Database.

Once you have verified the connection click “OK”.

The following screen will be back up again:

Click “Finish” to exit the wizard.
The log in for Asure 2009 now that it is connected to the SQL Database is:
User Name: admin
Password: admin

Safe-Card ID provides ID card printers and ID card software including Asure ID Software. Contact our ID card experts at 888-485-4696 for purchasing information.

Asure ID Express

Asure ID software is powerful id card design and printing software made by HID. The software is trusted by organizations of all sizes and is rich in features and easy to learn. The software is able to provide card design, data management, card production and developer tool benefits to provide the capability to produce professional id cards for groups, organizations and business.

The Asure ID Express is the stand alone photo id software. Containing many powerful features, this software exceeds the requirements of most small to medium businesses or high school applications. Following are the features of the Asure ID Express Software available in the versions of 5.x.

      Password log-on with definable user privileges

 

      Languages supported: English, French, German, Spanish

 

      Native support for MS Access

 

      Internet enabled (Send cards to an Asure ID Card Service Bureau for backup or primary card production.)

 

      Dual-sided template designs

 

      Supports all field types

 

      Add data fields

 

      Add photo fields

 

      Add signature fields

 

      Import logos

 

      Add linear bar codes

 

      Add magnetic stripe

 

      Set conditional design and print rules

 

      Save and search records(Storage limitations based on MS Access)

 

      Dual-sided printing

 

      Batch printing

 

      Integrated photo capture

 

      Integrated signature capture

 

      ODBC import

 

      Live Link™ (Real time data exchange – MS Access – single table only)

 

      Custom reports

 

    Optional Annual/multi-year support packages

For specific information about Asure ID Express, other Asure ID software versions or additional id card software options, contact our id card experts at 888-485-4696.

Asure ID Card Software – Adding a Bar Code to your Design

SafeCardID.com offers a free training video which demonstrates how to add a bar code field to an id card design designing an id card layout in Asure software programs.

For additional information about Asure ID Express card printing software, ID-card systems, printing supplies or badge attachments and accessories, contact us for a free consultation at 888-485-4696.

[blip.tv ?posts_id=1947539&dest=-1]