Help ! Connecting Progress 7.3c with ODBC

Help ! Connecting Progress 7.3c with ODBC

Post by Tiboldi Kalma » Thu, 26 Jun 1997 04:00:00



Hello,
        I'm traying to connect our main Progress 7.3c database running
in a IBM RS6000-R40 machine with AIX 4.2, with a PC running Delphi3 and
VB4 applications .
   I've downloaded the OpenLink Lite for Progress8 Large (32 bit) ODBC
driver and now I'm trying to use it, but I get no connection.
   My scenario:
      - In main computer the database is started with -S myservice -N
TCP parameters
      - In my PC running Win95, I've installed Progress 7.3d client,
ODBC data source administrator(latest version)
      - I've configurated a datasource with the following session
options:
         -db MyMainDatabase -S myservice -H myhost -N TCP
      - Both computers have the host and service files configurated
      - If I connect my PC Progress client to the Main database the
connection is established without any problem
      - If I'm trying to connect the Main database using the OpenLink
demo programm I'm getting every time an error :
     SQL State:08004    
     Native: 0
     Message : [OpenLink][ODBC][Driver] connection rejected by data
source.

    What is wrong in my scenario ?
    Is possible to connect Progress server running in a UNIX machine
with PC running Win95 in an efficient mode ?
     Thank in advance for your help.

                  Tibi.
--
 * Tiboldi Kalman       * TVH Forklift Parts * Tel: +3256434295 *

 * URL   : www.tvh.be   *      8560 Gullegem , Belgium          *

 
 
 

Help ! Connecting Progress 7.3c with ODBC

Post by sk » Fri, 27 Jun 1997 04:00:00


On the server, you have to set some env. variables (ODI*) before starting
the server. This could be the problem. I have used only the 16bit ODBC to
connect to Progress V7.3 via openlink (Lite) driver. If you have trouble,
please contact OpenLink support.

Sridhar Krishnan

Note: Please remove "_deletethis" before sending in a reply.
      Sorry for the inconvenience.


> Hello,
>         I'm traying to connect our main Progress 7.3c database running
> in a IBM RS6000-R40 machine with AIX 4.2, with a PC running Delphi3 and
> VB4 applications .
> options:
>          -db MyMainDatabase -S myservice -H myhost -N TCP


 
 
 

Help ! Connecting Progress 7.3c with ODBC

Post by Product Suppor » Sat, 28 Jun 1997 04:00:00


Hi Tibodli,

Please ensure you have downloaded the very latest cut of our 32 & 16 Bit
Single Tier (OpenLink  Lite) ODBC Drivers for Progress, the earlier release
had some incompatibilities at the Progress Client Networking Layer (no 16
to 32 bit thunking support etc.), these issues have now been resolved with
the release of 8.2A.

The new Lite release supports V7 & V8 DB Engines running on NT, WIN 95,
UNIX, VMS

Visit:http://www.openlinksw.com/docs/product.html
To download.

Regards,
Product Support
OpenLink Software


>Hello,
>        I'm traying to connect our main Progress 7.3c database running
>in a IBM RS6000-R40 machine with AIX 4.2, with a PC running Delphi3 and
>VB4 applications .
>   I've downloaded the OpenLink Lite for Progress8 Large (32 bit) ODBC
>driver and now I'm trying to use it, but I get no connection.
>   My scenario:
>      - In main computer the database is started with -S myservice -N
>TCP parameters
>      - In my PC running Win95, I've installed Progress 7.3d client,
>ODBC data source administrator(latest version)
>      - I've configurated a datasource with the following session
>options:
>         -db MyMainDatabase -S myservice -H myhost -N TCP
>      - Both computers have the host and service files configurated
>      - If I connect my PC Progress client to the Main database the
>connection is established without any problem
>      - If I'm trying to connect the Main database using the OpenLink
>demo programm I'm getting every time an error :
>     SQL State:08004
>     Native: 0
>     Message : [OpenLink][ODBC][Driver] connection rejected by data
>source.

>    What is wrong in my scenario ?
>    Is possible to connect Progress server running in a UNIX machine
>with PC running Win95 in an efficient mode ?
>     Thank in advance for your help.

>                  Tibi.
>--
> * Tiboldi Kalman       * TVH Forklift Parts * Tel: +3256434295 *

> * URL   : www.tvh.be   *      8560 Gullegem , Belgium          *

 
 
 

1. Need help : Progress 8.3c and ODBC driver Merant ver.3.60.00.00

Hallo,

We would like to connect a Progress 8.3c on Windows NT with a third
application
using ODBC driver ver.3.60.00.00 from Merant. The server answered
"[MERANT][ODBC Progress driver][PROGRESS]A PROGRESS database server
can not handle a
non-progress database connection". I'd set the environment variables
IDLC,
DLC and PROMSGS, also an entry in services file. The mode of
connection "DIRECT" (database server in the same
comp. with the driver and the application).

Anybody has the same experience or can give me some hints ?

Thanks,
Michael A. Purwoadi

2. How to trigger a task on arrival of a file

3. Connect to netware progress data server 7.3c

4. SQL 6.5 DB and Truncate Log Warning

5. ODBC Progress 8.3c with MS-Access

6. Accessing Foxpro from VB6 (3170 ISAM error).

7. ODBC and Progress V7.3c on Novell NLM

8. Drop Default

9. ODBC connection MS Access to Progress 6.3C UNIX

10. ODBC to connect Progress to a non-progress db

11. Help: ODBC-Connect from Notes to Progress with only one login

12. Cluster environment issue with OS 5.1a and Progress 8.3C

13. Progress v7.3d and 7.3c