Working with databases

[Zodra1]

Hi again,

I browsed and searched this forum for a couple of hours and I can't find anything about working with data(bases). How do I connect to a database e.g. MS SQL, Or any other database? Can I use SQL statements directly in code?

Regards,
Drago

[Pelle]

Connecting to a database usually depends on the database. ODBC (see http://en.wikipedia.org/wiki/Open_Database_Connectivity) is/was one attempt at supporting multiple databases through a common interface - I'm not sure how much it's used today. The SQL statements are most likely passed as strings to some API function that the database provides. I use SQLite in Pelles C, which is small and easy database engine to start with (see http://www.sqlite.org/). It works fine, unless you want to handle *huge* volumes of data...

[TimoVJL]

If you are interest about ODBC look at:
http://forum.pellesc.de/index.php?topic=2489.msg9458#new

[Zodra1]

Thank both for the answers. I would prefer something like MSDE. If possible

[TimoVJL]

You can connect to SQL Server or MSDE via ODBC, OLE DB, or DB-Library.
What you prefer to use except ODBC ?

DB-Library example code just for keywords to google.

Code: [Select]

// MSSQL database
PDBPROCESS dbproc; // The connection with SQL Server.
PLOGINREC login; // The login information.

int err_handler(PDBPROCESS, INT, INT, INT, LPCSTR, LPCSTR);
int msg_handler(PDBPROCESS, DBINT, INT, INT, LPCSTR, LPCSTR,
LPCSTR, DBUSMALLINT);
dberrhandle(err_handler);
dbmsghandle (msg_handler);
login = dblogin();
dbsetlname(login, 0, DBSETSECURE);
dbproc = dbopen(login, "local");
dbuse(dbproc, "test");
dbexit();


[Zodra1]

Connection to a set of SQL tables is exactly what i was looking for. Many thanks i will test this code as soon as i return from vacation. Thank you again.

[Zodra1]

Well it looked simple . But it isn't quite so. I found functions to be a part of MS SQL library. I know I must do something to access those SQL functions from Pelles but I don't know what. Will keep trying; help is of course welcome and needed  .

[TimoVJL]

If you use ODBC all nessessary files you get with Pelles C.
Why you don't want to start with that ?
When you learn to use that, you can use same code with several databases as i showed in that Tiny Lousy ODBC Hell.
Using DSN-less ODBC you don't have create datasource/change system settings
 because SQL Server connection files/dlls comes with MDAC/MSOffice.

http://www.easysoft.com/developer/languages/c/odbc_tutorial.html

[Zodra1]

Yes, you are right of course. In every aspect. Flexibility and independence is worth a lot. I will try to learn how to use ODBC.