Re: ODBC in UNIX?

On Fri, 28 Aug 1998 09:41:57 -0700, "Albert Landeck" <landeck@informix.com> wrote: >Hi Edward, > >You have plenty of options between third party ODBC drivers like Intersolv >provides and those drivers provided by the database vendors themselves. I >know that Informix has an ODBC/CLI driver for Unix that it produces. > >The question about which one to use can come across as a religious >discussion at times on the comp.database.* newgroups, everyone seems to have >their own favorite. This isn't quite so. The market now seems to be divided between SCO, OpenLink and the database vendors solutions. The discussions I have seen and taken part, in at least on comp.databases.informix, have been quite reasoned. There are simple and easy to understand issues why one driver is better than the other. By now most database vendors solutions are available for free. This is a reason for many to use them although the quality of the drivers may not be up to par. SCO and OpenLink have implemented a significant set of features that are not commonly available with the database vendors solutions. These include easy installation and maintenance and most importantly access security management. SCO supply drivers for use with most databases installed on most current Unix platforms. OpenLink in addition to most Unix platforms also have solutions for database servers intalled on Windows NT. This and the simpler installation and maintenance makes it the choice for us. Others have different priorities and selects differently. From most vendors you also get client side ODBC for most Unix clients as well as MS Windows (3.1, 95, 98 and NT). The end result is that ODBC drivers are as available and usefull in a Unix environement as on MS Windows both on the server and client side. >Al Landeck > >Edward wrote in message <35E3C165.8F3A44D9@tp.ac.sg>... >>Does anybody know whether there are any ODBC drivers or interface in >>UNIX environment? Someone told me that I can not use ODBC interface to >>access those famous databases, such as Oracle, Sybase and Informix etc., >>but can only use native SQL in an UNIX environment. Is that true? Does >>that mean Windows NT is better than UNIX at this issue? >> >>Any comment on this would be appreciated. >>Please reply to "liufeng@tp.ac.sg" >>Edward, Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)