[Piperlester]

And... if something compiles fine in Dev-C++, should it not compile (if all headers are still present) with Borland's compiler too?

[Amadeus]

<sql.h> is the usual set of libraries...but that can very...<sqltext> is another, and windows.h has SQL related functions as well.

[Piperlester]

Ok then, do I need to open the database or connect to it with a specific chunk of code? None of the tutorials I've looked at mention how to connect. They all just show manipulation of the DB.

[Amadeus]

Depends what database you are using, and the method...are you using ODBC, or ADO?

[Piperlester]

Ok, I've figured out that ADO seems to be considered the easiest (and I'm just going to start with a basic DB, with the base function of Add, Insert, Edit and Delete.

Is

http://www.developer...o.uk/show/4033/

a decent resource to use? (I don't want to get started with bad info.)

Thanks,

Me

[Amadeus]

That is a good enough starting resource, although it presumes you'll be using an ado import (make sure that dll is there on your system). What database software are you using?

[Piperlester]

I'm not sure what DB program I'll be using... I'm a little confused. What is the flow between my code and the actual database?

code opens connection with db server
code performs commands
code closes db connection


I'm not sure where the db program comes into play...

[Amadeus]

The db server is running some software...something like MySQL, SQL Server, something like that...or it will connect to an instance of a stand alone database, like Access...the connection string you use will differ based on what you are connecting to.

[Piperlester]

So if I'm running windows 2000 server and eventually plan on using a web interface to manipulate the db, MySQL would be the way to go?

(Next question would be is MySQL free for personal use?)

[Amadeus]

MySQL is a great choice...it is free for personal use. It is not just for web apps...you can access it with anything.

[Piperlester]

Great, thanks for the info . "I can see clearly now, the brain is gone..."

[Amadeus]

No problem, bur forgot to tell you...if you're going to use c++ and MySQL, then check this out...it's the C++ wrapper for the MySQL C API

[Piperlester]

That brings up another question... I looked into MySQL++ on my previous attempts to learn to DB... there's no flavour of MySQL++ (that I've found) that works with Dev-C++... and I've done all my programming in there recently... I don't have a problem using BCC (Borland), but for some reason I get lots of errors compiling things in BCC32, that worked fine in Dev-C++. I've made a post in C and C++ so as to keep C++ questions in the C++ forum.

Question:

This post has been edited by Piperlester: 03 December 2005 - 03:55 PM