Offer MySQL as an option... fully opensource and free, but DO charge for the installation of MySQL (this is your service).
I completely agree with this. Whenever you can build an app that isn't backend specific, you'll win points with integraters. If you can build an app that works with the big four, (Oracle, MS SQL Server, PostgreSQL, and MySQL), you'll have a lot more flexibility. Plus, you might find that a client already has one of these servers installed and you can add your app to their installation.
As far as a standalone desktop engine... The only three that I am aware of are Jet, MSDE, and Oracle Personal Edition. I believe that you can get licensing rights for any of these, but I don't know at what cost.
Andy