DB Connectivity Standard

[Bosko_Buha]

Hi,

I work for a company that developed a DB engine. My task is to port the software from windows to linux. Right now applications can communicate with the database through OLE/DB. Since OLE/DB is a Microsoft standard I need to write new DB interface for linux. I'm just trying to find out what the standard is. Is is still ODBC or is there something else? Can somebody please enlighten me? Thanks.

P.S. I need this to be C/C++ implementation.

[stuka]

There's not (that I know of) a 'standard' Linux interface for DB engines. However, for examples of existing interfaces, you could look at what is provided by MySQL or PostgreSQL (and PostgreSQL is open source, which may help with the porting). I'd imagine that you'll need similar functionality in any case: connection, database selection, all of the relevant DDL/DML functionality, and utility functions - an interface similar to ODBC would, I'm sure, be more than sufficient.

[Strike]

Well, while it's not a Linux-wide standard, PHP and Perl both have generic database interface libraries named DBI which share a common interface, I believe. The description of the perl DBI is here: http://www.fnal.gov/docs/products/perl/pod.new/site_perl/5.005/i686-linux/DBI.html#THE_DBI_CLASS