Hello all,
I have [attempted to] setup an ODBC connection to a PROGRESS 9.0B database
running on Windows NT. I am using Crystal Reports v7. Using Crystal, I can
connect to the databases fine and choose from a list of tables and fields
that I want to base my report on. Once I have selected my report criteria
and go to run (preview) the report, I get the following error message:
ODBC error: [MERANT][ODBC PROGRESS driver][PROGRESS]Access
denied(Authorisation failed)
.... with no associated error number.
The basic setup is as follows:
Server:
Windows NT Server 4 (SP4)
PROGRESS 9.0B (plus patch 018). Server started on database using TCP sockets
DLC/PROCFG/PROMSGS Env. variables setup correctly
PATH has DLC and DLC\BIN directories included
Client:
Windows NT Workstation 4 (SP4)
PROGRESS 9.0B (plus patch 018)
Merant 3.50 32bit PROGRESS SQL92 ODBC Driver
ODBC driver setup to connect directly to database using databases TCP port
number (not using OIB)
Logging on with valid user name and password (user has been setup with full
rights in database)
DLC/PROCFG/PROMSGS/IDLC/IPROMSGS/IPROCFG Env. variables setup correctly (not
sure whether the I.. vars are still required)
PATH has DLC and DLC\BIN directories included
The connection is made successfully and it only falls over when trying to
fetch data. Any Ideas?
M. Gill
I have [attempted to] setup an ODBC connection to a PROGRESS 9.0B database
running on Windows NT. I am using Crystal Reports v7. Using Crystal, I can
connect to the databases fine and choose from a list of tables and fields
that I want to base my report on. Once I have selected my report criteria
and go to run (preview) the report, I get the following error message:
ODBC error: [MERANT][ODBC PROGRESS driver][PROGRESS]Access
denied(Authorisation failed)
.... with no associated error number.
The basic setup is as follows:
Server:
Windows NT Server 4 (SP4)
PROGRESS 9.0B (plus patch 018). Server started on database using TCP sockets
DLC/PROCFG/PROMSGS Env. variables setup correctly
PATH has DLC and DLC\BIN directories included
Client:
Windows NT Workstation 4 (SP4)
PROGRESS 9.0B (plus patch 018)
Merant 3.50 32bit PROGRESS SQL92 ODBC Driver
ODBC driver setup to connect directly to database using databases TCP port
number (not using OIB)
Logging on with valid user name and password (user has been setup with full
rights in database)
DLC/PROCFG/PROMSGS/IDLC/IPROMSGS/IPROCFG Env. variables setup correctly (not
sure whether the I.. vars are still required)
PATH has DLC and DLC\BIN directories included
The connection is made successfully and it only falls over when trying to
fetch data. Any Ideas?
M. Gill