StarQuest Technical Documents

StarSQL Login Frequently Asked Questions

Last Update: 26 June 2008
Product: StarSQL
Version: 5.x
Article ID: SQV00SQ032

Abstract

This article answers frequently asked questions (FAQs) about using StarSQL logins.

How can I automate my StarSQL data source login?
How can I prevent the User ID from appearing in the StarSQL connection dialog?
How can I encrypt the User ID and Password (StarSQL 5.3x or later)?

Solution

How can I automate my StarSQL data source login?

You can automate StarSQL logins so that the user does not have to enter in a User ID and Password when making a connection. Please see StarQuest Technical Document, How to Automate StarSQL Logins for detailed instructions.

Return to the top

How can I prevent the User ID from appearing in the StarSQL connection dialog?

In the Expert Page of the StarSQL data source configuration, change the CacheUID parameter value to No.

The default for this value is Yes. 

Return to the top

How can I encrypt the User ID and Password (StarSQL 5.3x or later)?

In the Security/Accounting page of the StarSQL data source configuration, check the Enable User ID/Password Encryption box and select the appropriate radio button. If you are unsure whether or not your DB2 supports encryption, consult your DBA. For more information, refer to the Configuring Security and Accounting topic in the StarSQL help.

Return to the top


DISCLAIMER

The information in technical documents comes without any warranty or applicability for a specific purpose. The author(s) or distributor(s) will not accept responsibility for any damage incurred directly or indirectly through use of the information contained in these documents. The instructions may need to be modified to be appropriate for the hardware and software that has been installed and configured within a particular organization.  The information in technical documents should be considered only as an example and may include information from various sources, including IBM, Microsoft, and other organizations.