Page 1
IntelliCAT
Editing/Changing an unencrypted
UDL file for IntelliCAT and a SQL DB
Installation User Support Document
Manual Part
99875663-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
March, 2014
Number:
Page 2
Copyright © 2014 MagTek, Inc.
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
<IntelliCAT>| <Installation User Support Document>
Page 3
<IntelliCAT>| <Installation User Support Document>
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
encoding if the
be
used
If the IntelliCAT Controller module is used, Motorized IntelliCoder Date checking is imperative
many
Motorized
Date Codes, dating before and after January 1, 2008, it is
7 32bit ONLY.
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
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.
a Win 7
in a Win 7
IntelliCAT customers have made multiple purchases over many years. Some or all of your
IntelliCoders
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.
64bit environment,
Motorized IntelliCoder
64bit environment
may have been purchased before January 1, 2008. If you have a mixed set of
ONLY
the
IntelliCAT Data
is dated before
if the date
code
Entry
module may be
January
is before January1 , 2008. See below.
1, 2008. IntelliCAT
recommended
Professional
to purchase or upgrade Win
Services
used
Controller
Agreement
will be
for card
may not
as
Page 4
<IntelliCAT>| <Installation User Support Document>
Unencrypted UDL file SQL Server 32bit64bit
Editing/Changing an unencrypted UDL file for IntelliCAT and a SQL DB
Navigate to the IntelliCAT.UDL or the IntelliCAT64.UDL or the IntelliCATSQL.UDL as noted in the
[ODBC] section of the desktop INTCAT.INI file. This may be a local file in C:\Program
Files\MagTek\IntelliCAT\
or it may be on a network location. If it is on a network location, no changes are required. Skip this
Step.
1. Right-click on the UDL and choose "Properties":
(32 bit install) or C:\Program Files
(x86)\MagTek\IntelliCAT\
(64bit install)
Page 5
<lntelliCAT> I
<Installation
User
Support Document>
I
2. Go to
the "Provider"
IntelliCAT.
udl Properties
All
General
Select the data you want to connect to:
0LE DB Provider
MediaCatalogDB
MediaCatalogMergedDB OLE DB
MediaCatalogWebDB OLE DB
Microsoft
Microsoft 0LE DB Provider For Data Mining
Microsoft 0LE DB Provider for D
Microsoft OLE DB Provider for
Microsoft OLE DB
Microsoft OLE DB
Microsoft OLE DB Provider for OLAP Services
Microsoft 0LE DB Provider for 0r
Microsoft OLE DB Provider for
Microsoft OLE DB Prov1der for SQL
Microsoft OLE
Microsoft Project 10.0
MSDataShape
OLE DB Provider for Microsoft Directory
OK Cancel
tab
Provider
s
0LE
Jet 4.0 OLE DB
Provider for Internet
Provider for ODBC
DB
Simple
and select "Microsoft OLE DB Provider
I
Security
DB
Provider
Provider
Provider
0LE
DB
Connection
Provider
Provider
TS
Indexing
acle
Outlook Search
Provider
Services
Packages
Ser
vice
Publishing
Driver
s
Server
Services
Summary
Advanced
8.0
Next
»
Help
? X
for
SQL
Server":
Page 6
<IntelliCAT>| <Installation User Support Document>
3. Go to the "Connection" tab and specify the server and database to be used. Windows NT
Integrated security is recommended. Or use User Name and Password, if preferred.
4. Click "Apply" then "OK" & TEST CONNECTION.
5. If Controller is used, create a Controller64.UDL. Under properties, change the connection string to
reference
C:\Program Files (x86)\MagTek\IntelliCAT\MtAdmin.MDB
The settings have been saved. Although it is not required, it is advisable to encrypt this file from
Administrator. Once encrypted, it cannot be open or viewed.
Loading...