c program against databases

.Path: uustar.starnet.net!uustar!wupost!news.starnet.net!news.starnet.net!newsÿ

. .cc.ukans.edu!arclight.uoregon.edu!feed1.news.erols.com!news
From: "Lan H. Tran" <lantran_at_ventera.com>
.Newsgroups: comp.databases.informix,comp.databases.oracle
Subject: c program against databases
.Date: Thu, 13 Mar 1997 16:54:26 -0500
.Organization: Ventera Corporation
.Lines: 21
.Message-ID: <33287792.3C6D_at_ventera.com>
.Reply-To: lantran_at_ventera.com
.NNTP-Posting-Host: spg-as24s07.erols.com
.Mime-Version: 1.0
.Content-Type: text/plain; charset=us-ascii
.Content-Transfer-Encoding: 7bit
.X-Mailer: Mozilla 3.0 (WinNT; I)
.Xref: uustar.starnet.net comp.databases.informix:43632
 

hello,
i would like to write a unix-based c program that would perform SELECT and INSERT against a database. i am very familiar with esql/c. however, i would like to productize this program and allow it to work with a variety of databases (Informix, Oracle, Sybase, DB2) on a variety of operating systems (variations of unix and NT, maybe).  

is the best way to write embedded sql c code (and recompile using esql/c, pro*c, etc...)? how standard is this? is there a good toolkit to help me out? is there a good book or website to learn more? how do app dev packages like IEF do it?  

it seems like i would have to buy alot of precompilers. for example, 4 databases running on 5 platforms would require 20 (4 x 5) esql/c like compilers. is this true?  

i would appreciate any guidance.  

Lan H. Tran
Ventera Corporation
lantran_at_ventera.com Received on Thu Mar 13 1997 - 00:00:00 CET