ODBC vs Dataservers

[Chris Kelleher]

Hi,

A colleague just asked me a question regarding ODBC ...

Question:
If ODBC is considered to be so great now (as opposed to a couple of years
ago), why do we use the Oracle/AS400 dataservers etc? Isn't it possible to
to access those DBs (and others) from Progress via ODBC?

Has anyone any thoughts on this? Does it make sense? Is it even possible?
If it is possible, do the cost savings benefits of going to ODBC outweigh
the performance risks not using the DataServers?

TIA,
Gord

*
* Gordon Campbell - Development Manager
* EFA Software (403) 294-6981
* Suite 800, 605 5th Ave SW, Calgary, AB, T2P 3H5
* mailto:gcampbell@efasoftware.com
*

 

[Chris Kelleher]

At 04:05 PM 10/22/99 -0600, Gordon Campbell wrote:
>Hi,
>
>A colleague just asked me a question regarding ODBC ...
>
>Question:
>If ODBC is considered to be so great now (as opposed to a couple of years
>ago), why do we use the Oracle/AS400 dataservers etc? Isn't it possible to
>to access those DBs (and others) from Progress via ODBC?
>
>Has anyone any thoughts on this? Does it make sense? Is it even possible?
>If it is possible, do the cost savings benefits of going to ODBC outweigh
>the performance risks not using the DataServers?
>

Gord,

Your colleague is confused with ODBC in and ODBC out. "It's
so much better now" is the ODBC drivers. That's got nothing
to do with the ODBC DataServer. ODBC is still ODBC compared
to native access methods, you really want to avoid the extra
layers if you can.


=================================================================
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
One World, One PEG