Very Computer

Any info would be most appreciated.

Progress client -> Progress server works fine.
Informix client -> Informix server works fine.
Delphi client -> Informix server works fine.
Delphi client -> Progress server dies. I set it up using the Progress
tools, ran the quick test. All worked fine. But I have yet to get any sort
of successful connection from Delphi to Progress. Best I have got is to
use the Form Expert (once) to find the table list and build a grid form.
Attempting to execute it caused a GPF from the Progress ODBC driver.
Subsequent attempts have been equally unsuccessful.

At this point, I *strongly* suggest using a third party driver. I
certainly intend to waste no more time on it. Needless to say, I'd be
delighted if someone has it working reliably and can enlighten us.

Peter Wiley

Don't use ODBC for mission-critial applications. Period. ODBC is very
useful for allowing database access to various third-party query-related
tools, but I wouldn't depend on it for database updates in a mission-
critical environment. This is especially true for Progress, whose backend
database isn't very good at doing SQL in V7 (V8 is a whole different
ball game).

--
Ebbe Jonsson, BOFH                                    Fax: +358 0 338 822
" Static on your frequency                            Phone: +358 50 553 53 97
  Electrical storm in your veins " - Rush: The Pass

: Unfortunately, Progress ODBC drivers *still* seem broken. I have Progress
: for Windows V8.0A, configured on a W4W box connected via tcpip to a Sun

: Delphi client -> Progress server dies. I set it up using the Progress
: tools, ran the quick test. All worked fine. But I have yet to get any sort

I suspect that this has to do with the fact that the Progress ODBC driver
doesn't support multiple connections to the same DSN unless you're using
a multiuser setup. V73B didn't support multiple DSN connections at all,
V8 is supposed to support them, but the instructions in the ODBC driver
manual are confusing to say the least.

Delphi does require that the DSN support multiple connections, especially
in design mode.

--
Ebbe Jonsson, BOFH                                    Fax: +358 0 338 822
" Static on your frequency                            Phone: +358 50 553 53 97
  Electrical storm in your veins " - Rush: The Pass

It still doesn't work with Delphi. If I have to have a multiuser Windows system to get ODBC to
work, I don't think I'll bother. Though it migh work with a later version of the server. When
I get time, I'll test it against a 7.3C server I have to install on a new machine. Live in
hope....

Peter Wiley

(Mind you, V8 has removed a lot of my reasons for wanting to run Delphi. But I feel that if
s/ware is purported to work, then it should.)

In my past experience, I only recommend my clients to use ODBC for
mission-non-critical applications. e.g. Making simple inquiry.

If you REALLY want to use ODBC with Progres, the only product I recommend
is OPENLINK. It is the most reliable driver. Mind you, I have nothing to
do with OPENLINK, I recommend it simply because it is EXCELLENT.

Brett Rogers
Professional Computer Systems, Co.
Denison, IA

Quote:

>Is any one out there running a Windows based app. written in Delphi or
>VB and connecting to PROGRESS V7 UNIX db via ODBC ??  
>If so, how reliable is it, is it workable for a Windows-Unix mission
>critical app. (I'm most interested in the reliability of the ODBC
>connection. )

Suman Palit
Sherwin-Williams Automotive Technical Center
Color Research and Management
Chicago

: only V7.3b and above that are ODBC compliant. The local Tech rep
: said 7.3c was really more stable as regards ODBC. Other than that,
: I'm still trying to sort out some VB4.0 isssues regarding connection
: to ODBC sources. If anyone has actually built a working c-s app, I
: would love to hear about it too.

I've done it (with several front ends) for test purposes. Nothing more
than non-trivial master-detail stuff as yet, since the Progress ODBC
driver isn't very stable, nor is its performance acceptable in update/
modify situations.

Haven't used VB4, so I can't comment on that.

--
Ebbe Jonsson, BOFH                                    Fax: +358 0 338 822
" Static on your frequency                            Phone: +358 50 553 53 97
  Electrical storm in your veins " - Rush: The Pass

I've used both OpenLink ODBC and Progress' ODBC.  OpenLink's is much,
much, much better.  It is stable and fast.  We are currently using it with
Access and a V7 database on SCO Unix.

I've also been able to use it with Delphi but for "read-only" access, so
far.

You can download a trial version of their product from:

http://www.openlink.co.uk/

Hope this help.

Ali.