Specifications

Using Databases with ID Works Projects 87
ID Works Basic Version 5 Administrator’s Guide
Database Login
You access the database when you use the Field Connections
window in ID Works Designer. In ID Works Production, Reporting,
and View, you access the database when you open a project that has
connections to a database.
If the database you will connect to requires a user name and
password for access, the Project Properties dialog box, Data Source
tab, Database Login area gives you have three choices for setting up
your project:
Use database login settings—ID Works users must supply a
separate database user name and password to access the
database.If you enter a user name and password in the Connection
tab of the Data Link Properties dialog box, the user name may be
displayed as a default name in the database login prompt.
Use ID Works user name and password—The ID Works
application passes your ID Works user name and password to the
database server whenever you access the database. If you choose
this option, you must assign the same user names and passwords for
ID Works access that the database administrator assigns for
database access. In addition, you should warn ID Works users not to
change their ID Works passwords. If an ID Works password were
changed and then passed to the database server, the database
security software would detect a wrong password. Depending on the
database used, the user might be asked to reenter the database
password or the user might be denied access. If you choose the Use
ID Works user name and password option, do not enter any user
name or password information in the Connection tab of the Data Link
Properties dialog box.
Use this user name and password—The ID Works application
passes the user name and password you supply for the project to the
database engine whenever you access the database. Because the
user name and password are not displayed, users cannot use them to
gain access to the database outside of an ID Works application. This
offers a higher level of security.