Problem with MERANT 3.50 32bit PROGRESS SQL92 ODBC Driver

Chris Kelleher

Administrator
Staff member
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
 

Chris Kelleher

Administrator
Staff member
At 11:05 AM 1/20/00 -0000, Manjinder Gill wrote:
>
>ODBC error: [MERANT][ODBC PROGRESS driver][PROGRESS]Access
>denied(Authorisation failed)
>
>.... with no associated error number.
>

This indicates you forgot to GRANT the access rights to the
SQL tables.

>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


Those are needed to start the database server, they no longer
have anything to do with ODBC.

>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
>

IDLC, etc. is no longer needed, this is a totally different driver.

>The connection is made successfully and it only falls over when trying to
>fetch data. Any Ideas?
>


PS You do realize this is an SDK product and not commercial, ie supported?
It's also the wrong list for this, you would want to be on the
SQL 92 list.


=================================================================
Geoff Crawford Phone: (973) 361 - 4224
Innovative Client Servers FAX: (973) 537 - 6946
75 Fleetwood Drive, Suite 200 Email: geoff@innov8cs.com
Rockaway NJ 07886 Web: http://www.innov8cs.com
Orange and Black Forever
 
Top