title: Programming for various database
body: <p>I'm wondering for those enterprise programs, how do they link to various type of database just by stating the connection string?  </p>
  
  <p>Issues like different syntax, variable type will definitely be there.<br>
  Apart from stored procedures for each type of database, how else do they handle in terms of their programming?  </p>
  
  <p>1 way that came to my mind is just if else checking of database in order to populate different query.  </p>
  
  <p>Asking as I'm curious while using a engine which is built in C++ and jsp, but could support SQL Server, Access, MySQL, Oracle</p>