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
Connecting to a database usually depends on the database. ODBC (see http://en.wikipedia.org/wiki/Open_Database_Connectivity (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/ (http://www.sqlite.org/)). It works fine, unless you want to handle *huge* volumes of data...
If you are interest about ODBC look at:
http://forum.pellesc.de/index.php?topic=2489.msg9458#new (http://forum.pellesc.de/index.php?topic=2489.msg9458#new)
Thank both for the answers. I would prefer something like MSDE. If possible
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.
// 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();
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.
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 ???.
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 (http://www.easysoft.com/developer/languages/c/odbc_tutorial.html)
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.