MagTek 99875664 User Manual

Download

IntelliCAT

Creating a 64 bit UDL for MtAdmin.MDB

Installation User Support Document

March, 2014

Manual Part Number:

99875664-1.01

REGISTERED TO ISO 9001:2008

MagTek I 1710 Apollo Court I Seal Beach, CA 90740 I Phone: (562) 546-6400 I Technical Support: (888) 624-8350

www.magtek.com

Rev Number

Date

Notes

1.01

March 21, 2014

Preliminary Release

Printed in the United States of America

Information in this publication is subject to change without notice and may contain technical inaccuracies or graphical discrepancies. Changes or improvements made to this product will be updated in the next publication release. No part of this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of MagTek, Inc.

MagTek® is a registered trademark of MagTek, Inc. ExpressCard 2000 is a trademark of MagTek, Inc. MagnePrint® is a registered trademark of MagTek, Inc.

Microsoft® and Windows® are registered trademarks of Microsoft Corporation. All other system names and product names are the property of their respective owners.

Table 0.1 - Revisions

Introduction

MicroSoft® announced XP will become obsolete in April 2014. For current users of IntelliCAT on an XP system, MagTek recommends upgrading to Windows 7, 32bit PC’s. Windows 7, 64bit may be used but there is a hardware limitation if Controller is used in the environment with respect to Motorized IntelliCoders purchased before January 1, 2008. Operating systems above Win 7 are neither certified nor supported by MagTek.

All Motorized IntelliCoders, regardless of the date code, will work in a Win 7 32bit environment.

If utilizing a Win 7 64bit environment, ONLY the IntelliCAT Data Entry module may be used for card encoding if the Motorized IntelliCoder is dated prior to January 1, 2008. IntelliCAT Controller may not be used in a Win 7 64bit environment if the date code is before January 1, 2008. See below.

If the IntelliCAT Controller module is used, Motorized IntelliCoder Date checking is imperative as many IntelliCAT customers have made multiple purchases over many years. Some or all of your Motorized IntelliCoders may have been purchased before January 1, 2008. If you have a mixed set of Date Codes, dating before and after January 1, 2008, it is recommended to purchase or upgrade Win 7 32bit ONLY.

Critical Note: If the date code on the bottom of the Motorized IntelliCoder is dated before January 1, 2008, the IntelliCAT Controller module may not be used in Win 7 64bit PC’s. Data Entry may be used, as a direct connect, but the other IntelliCAT workstations that share the Motorized IntelliCoder will no longer be supported. Contact your MagTek Sales Representative at 562-546-6400 to discuss new options.

Prior to setting up the new PC, regardless of the new O.S, it is very important to keep the old PC on to retrieve specific files that will need to be copied for use with the new installation. Failure to copy the required files will be time consuming and a chargeable Professional Services Agreement will be required.

The following are instructions to upgrade the IntelliCAT System. If assistance is required, please call or email support@magtek.com to schedule a Professional Services appointment.

IntelliCAT64.UDL

C:\Windows\syswow64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB \oledb32.dll",OpenDSLFile C:\IntelliCAT64.UDL

Win 7 64bit – Creating a 64 bit UDL for MtAdmin.MDB

To create an IntelliCAT64.UDL from scratch on a Windows 64bit O.S. for use with MtAdmin.MDB:

1. Create a new text file under the root of C:\ and name it IntelliCAT64.txt

2. Right-Click on C:\IntelliCAT64.txt and select Rename the file’s extension. Change the

extension from TXT to UDL. The new file name will be IntelliCAT64.UDL.

3. Next, go to the Windows Start Menu and in the first field "Search programs and files" type in

RUN and click OK

4. In the Run Window next to the Open field paste or type in the following exactly:

C:\Windows\syswow64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile C:\IntelliCAT64.UDL

and click OK

Note, if you copy the existing installed IntelliCAT.UDL from C:\Program Files (x86)\MagTek\IntelliCAT\ it will not work, you must create a new one following Step 1 above.

5. The following will display:

6. Switch to the Provider Tab and the Microsoft Jet 4.0 OLE DB Provider should be displayed, click on it to highlight it:

7. Switch back to the Connection Tab and browse or key in the default path (or network path) where the IntelliCAT Access DB is to be used (MtAdmin.MDB):

8. Switch to the ALL Tab and Select the DB Name "Jet OLEDB Database Password" as shown below and then click the "Edit Value" button:

9. Type in the encrypted MtAdmin.MDB database password (all lower case) under the Property Value field: symaginecg

10. After selecting OK to the above Property Value, asterisks will appear next to the Jet OLEDB Database Password as shown below:

11. Switch back to the Connection tab and click on "Test Connection"

12. If successful, it will show it succeeded:

13. Click OK and copy the configured IntelliCAT64.UDL from C:\IntelliCAT64.UDL to the default

directory of C:\Program Files (x86)\MagTek\IntelliCAT or to the appropriate directory defined in the [ODBC] section as noted in the desktop copy of the INTCAT.INI file.

14. If an Operators folder is used, make a copy of the configured IntelliCAT64.UDL and rename it to Operator64.UDL, Open the Operator64.UDL properties and change the Connection String to point to the appropriate folder for the MtAdmin.MDB file, either Local or Networked. Copy the Operator64.UDL to the appropriate folder defined in [ODBC] section.

15. If Controller is used, make a copy of the configured IntelliCAT.UDL and rename it to Controller64.UDL. Open the Controller64.UDL properties and change the Connection String to point to the appropriate folder for the MtAdmin.MDB file. Local is always used. Copy the Controlller64.UDL to the appropriate folder defined in [ODBC] section.

MagTek 99875664 User Manual

Specifications and Main Features

Frequently Asked Questions

User Manual