Specifications

Production-only Systems 141
ID Works Standard and Enterprise Version 5 Administrator’s Guide
Database Considerations
Will your Production users access a central database on the
network? The settings you must make depend on the database
product used:
• Access — Use the full path name (not a mapped drive) to specify
the database connection on the Data Source tab of the Edit
Project Properties dialog box. Using the full path name means
you do not have to ensure that all the computers in your system
map drives the same way. See Chapter 5, Using Databases with
ID Works Projects, for more information.
• Oracle — Each client must have a matching service name.
• SQL Server — Each client must have access to the server and
database named in the project.
• OLE DB provider for ODBC drivers — You must create an
identically-named ODBC data source on each computer on which
you install ID Works software. (A System DSN is recommended.)
You access the ODBC Data Source Administrator through your
computer’s Control Panel.
If your Production users will work with a copy of the database on a
local hard drive, the database must be located in exactly the same
path on all computers in the system.
Consider developing stored database searches for queries that your
Production operators will perform repeatedly. Stored searches are
created using the Advanced Search editor in the ID Works Production
application and exported with projects.