Kbase P12812: SQL-92 database access using Kofax's Ascent Capture front end application
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/16/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Making SQL-92 connections to database
Using Kofax's Ascent Capture front end application
Need to access public tables (pub.tablename) without using pub prefix
CHANGE:
Using Kofax's Ascent Capture application
CAUSE:
Kofax's Ascent Capture can not create queries with "pub." in front of an entity. Application unable to modify the way queries are formatted.
FIX:
1. Create a user "pub"
2. Log in as user pub.
3. The pub user will be able to access the tables without the prefix pub