inGOT Notification #010006

HOWTO: Setting up inGOT ASP Pages

Information in this article applies to:

- inGOT v3.x and v4.x
- Microsoft Windows NT/2000/XP Domain
- Microsoft Access or SQL Database Logging

Installation

Install the appropriate set of asp pages onto the web site area of a server running IIS. This is usually located at \\<servername>\c$\inetpub\wwwroot. We recommend putting them in a UserInfo folder.

Create a System DSN ODBC connection for these pages. We recommend calling the ODBC connection "inGOTDetails". If connecting to a MS-SQL database we recommend creating a new "read only" login account and give it read only access to the main inGOT SQL database. (i.e. don't use the SA account)

Both inGOT ASP web pages (USERINFO.ASP and ALLUSERINFO.ASP) will need to be altered.

For both MS-Access ASP Pages locate the following line...

Set connDB = OpenDB("DSN=inGOT; UID=admin; PWD=")

... and ensure that the DSN name (DSN=inGOT) is the same as the DSN ODBC connection just created. The UID and PWD do not need to be altered.

For both MS-SQL ASP Pages locate the following line...

Set connDB = OpenDB("DSN=??DSN_NAME??; UID=??SQL_USER_NAME??; PWD=??SQL_USER_PASSWORD??")

... and ensure that the DSN name (??DSN_NAME??) is the same as the DSN ODBC connection just created. The ??SQL_USER_NAME??and ??SQL_USER_PASSWORD?? fields need to be changed to the MS-SQL user name and password.

To replace the generic Liverton logo etc, you need to replace the logo.gif file with one of your own. You can change where the logo links to, by changing the details in the logo.txt file.

You can put disclaimer text in the disclaimer.txt file where it says "Disclaimer here" (please don't disturb the structure of the file).

USERINFO.ASP

When a user loads this page it will automatically look up their login ID and then look up their inGOT balance and other traffic information.

ALLUSERINFO.ASP

This page will show the balance of all users in the database. The login account attempting to access this page needs to be of "inGOTAdmin" user type in the inGOT database.

For further clarification please contact the Liverton support team at .

Copyright Liverton Ltd. ©2002