Might just have been a typo on your part, but I''m pretty sure just must pass the address of it, ie mysql_init(&datesdb);.

quote:Original post by flukus
Well datesdb is a pointer so it should do the same thing.

No it wouldn''t. But, anyway, read the documentation again:
http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_init. (it is not consistent with how you described it in the original post).

Please post your code, and it might be easier to spot.

quote:Another question though, Is MySQL suitable for a client side database?

If you mean installing the server at clients, then maybe not. I think there are other "versions" of MySQL available for stuff like that.

quote:Original post by flukus

quote:
19.1.3.31 mysql_init()

MYSQL *mysql_init(MYSQL *mysql)
Description

Allocates or initializes a MYSQL object suitable for mysql_real_connect(). If mysql is a NULL pointer, the function allocates, initializes, and returns a new object. Otherwise, the object is initialized and the address of the object is returned. If mysql_init() allocates a new object, it will be freed when mysql_close() is called to close the connection.
Return Values

An initialized MYSQL* handle. NULL if there was insufficient memory to allocate a new object.
Errors

In case of insufficient memory, NULL is returned.

Is there something I''m missing there, because as far as I can seee thats what I have. Does "MYSQL *mysql_init" mean it''s a function pointer or something? Because I''ve never dealt witht hem befor.

No function pointer

What I figure, mysql_init() has two modes:

1) You allocate (and is responsible for later freeing) a MYSQL data structure (not just a pointer). In this case you give mysql_init() the address of this structure.

2) You let the library allocate (and freeing) the MYSQL structure. You do this by passing a NULL pointer to mysql_init().

In both cases the function should return the address of the structure, whether you or the function allocated it. You said in the original post that a zero return indicated no error. However, the documentation I quoted previously says that a NULL means error.

So, it seems that MySQL fails to be initialized. I am *very* rusty on MySQL''s C API, but I think you can get what went wrong through the error function (mysql_error()?).

quote:Also, do you know where I can find more information about those other "versions" of MySQL? Or what keywords I should google?

Actually, no. I''ve heard that there are libraries for "embedded" applications, and as I figure a way to have client and server in the same application. I don''t know any specifics, but you should be able to find info on www.mysql.com or try their mailing list or its archives (available from their site).

quote:Original post by flukus
I tried number 1 befor (sorry, I''m away from my computer right now so I can''t try again) something like this:

MYSQL datesdb;

mysql_init(&datesdb);

That will do, but:

quote:MYSQL *datesdb = NULL;

datesdb = mysql_int(datesdb);

will also work. Although that you pass the null pointer to mysql_init() might indicate that you misunderstand it. This should be enough:

*datesdb = mysql_int(0);

quote:Original post by flukus
I figured it was like the way you pass pointers to directx.

Yes, I considered it first too, but you were not passing a pointer to a pointer (which is the case in DirectX), hence my first comment.