PROBLEM: Can't find Database Name when running within an ASP in a Web application

The information in this article applies to:

• Acceler8DB, Release 4.6 and above
• ASNA Visual RPG
• ASP
• IIS
• MTS / COM+
• Web
• Deploy

SYMPTOMS:

An ActiveX which uses Acceler8DB to access data from the server can't seem to find the Database Name given the error:
    Error 610 - "Database is not available or does not exist".

The Database Name seems to exist because a GUI program using the ActiveX itself or at least the same Database Name works correctly; however, when run within IIS it fails.

CAUSE:

The problem with the ASP not finding the name is due to the fact that ‘Database Names’ are kept on a per-user basis. IIS ASPs usually run in a process (within COM+ / MTS) under a User Profile (i.e. an Identity) different than the Interactive one used by the programmer (see the NutPack Properties Image below).  The Name created by the programmer (or administrator) is 'private' to his user profile, so the IIS process can't see the programmer's Database Names.

RESOLUTION:

The solution to the problem is to create a PUBLIC Database Name. You do that by Prepending the keyword *Public to the name like the following dialog shows. In this case the program would use the name ‘DbASP’ (or whatever you called your database). Because the DB is Public, it is stored in the ‘Machine Register’ (HKEY_LOCAL_MACHINE). Regular DB Names are kept in the ‘Current User’ registry (HKEY_CURRENT_USER). Please see the help documentation regarding Public Database Names, especially the security section.

You must now change your AVR applications to reference your database name with the "*Public/" preamble; e.g., DBDESC ("*Public/DbASP").

MORE INFORMATION:

Other ASNA KB Articles:

• INFO: Differences between Private and Public Database Names
• Errors Occur When the MTS Identity Is Not Set to the Default User
• PRB: Server Execution Failed When Calling MTS COM Component from ASP
• HOWTO: Deploying your Web Applications

Keywords: "database name not found", web, 610, Public, Identity, COM+, MTS, deployment, client