SQL Compact

[Mycroft Holmes]

I'm looking at an embedded database requirement, basically users need to operate unconnected so I was intending to supply SQL Compact but it seems it does not support stored procs. There goes 99% of my DB code. Is there a single user SQL database that supports procedures (forget Access I get hives just thinking about it). I would like to have a single codebase for both the main database and the local DB and I really didn't want to install a server version.

Never underestimate the power of human stupidity RAH

[i j russell]

I would recommend Firebird. It has embedded and server versions, is fully featured, is pretty much ANSI-compliant and it's free!