I use Access at work, and we need an SQL server to get live data off a database (think that's how it is), but at home I don't have an SQL server installed on my computer. When I execute access queries on tables embedded in the Access database, they work just fine.
Is there a way to use SQL in an application without having an SQL server? What libraries can I use? What kind of database could I use it on?
I can't think of why you would want to use SQL in an application with having an SQL server. SQL is a language designed for communicating with databases. You could probably make a program that recieves SQL requests from other programs and does something with them other than access a database, but you're spinning your wheels with that one. It's really not clear what you're asking. It sounds like you don't fully understand what is happening on your network and why you need SQL, so the only thing I can recommend is that you go read about the subject. Do you have a specific question where you can give us more information about what you're trying to do.
To answer your other questions, in C++ there is no standard SQL/database library, but there are many APIs available for this purpose, and using streams in C++ you could make your own from scratch. I do however, see no relevancy to C++ in your questions, so this may be better at the Tech Board (mods?). You can use an SQL client on any database that accepts SQL. MySQL is free an good for learning, etc... but if this is for work and you'll be using Access, etc.. you may want something more professional.
Well basically I have been wanting to make some Bible software, and I want to be able to search for keywords easily. I know you can search for things easily with SQL.
I would like to use SQL if possible to search through it. Is there a way I can do this?
Or is there a better way? I want users to be able to download the program and the Bible database file and not have to install a whole bunch of stuff to go along with the program.
I am looking into sqlite (http://www.sqlite.org).
In my opinion, SQL is a bit too high-level for this kind of a project, but maybe I'm just not looking at it properly. It is easy to make search algorthms in C++, and since it is just your program that is accessing the database, maybe you should make your own file format (really not that hard - something close to a standard text file should be fine). If you had the program access the database online, then maybe SQL and a distributed database would be a better option, but for this type of a project, making your own search algorithm is your best bet. www.aihorizon.com has some articles on making efficient search functions, etc...