Nico Heinze wrote: > --- In [email protected], SMD <[EMAIL PROTECTED]> wrote: >> On Tuesday 13 March 2007 14:23, kose_senol wrote: >>> Could someone advice me a good book or a good site(www....com) >>> about using C++ codes for SQL, e.g, retrieving information >>> from databases using C++ CLASSES OR functions ,changing values >>> and tables,updating or deleting ,adding new record to tables. > <snip> > > If you don't want to work for some specific database only (and trust > me, I know quite a few companies which have chosen to switch to > another DBMS even though they knew this would cause much trouble), I > would suggest you first work with ODBC; this is a universal interface > to relational DBMS, and it's really not bad. > > Regards, > Nico
Thank you Nico. I don't know why anyone recommends anything else. ODBC is available for *NIX as well as Windows although Windows' implementation of ODBC has more prominence (weird, huh?). Platform independence is another excellent reason to use ODBC. The ONLY downside to ODBC is that it takes a VERY MINOR performance hit per query (<1ms to 5ms depending on the RDBMS' ODBC implementation when compared to the same RDBMS' raw API implementation - most modern ODBC implementations are a lightweight layer around the API and the only real transactional cost involved any more is making a connection to the backend DB). In other words, use ODBC unless you need some extremely high-performance from the app. (i.e. you are going to be running several thousand SQL queries per second). -- Thomas Hruska CubicleSoft President Ph: 517-803-4197 *NEW* VerifyMyPC 2.2 Change tracking and management tool. Reduce tech. support times from 2 hours to 5 minutes. Free for personal use, $10 otherwise. http://www.CubicleSoft.com/VerifyMyPC/
