1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
MYSQL *mysql;
MYSQL_RES *results;
MYSQL_ROW record;
static char *server_options[] ={ "mysql_test", "--defaults-file=C:\Program Files\Borland\CBuilder6\Projects\soft_diete\my.ini", NULL };
int num_elements = (sizeof(server_options) / sizeof(char *)) - 1;
static char *server_groups[] = { "libmysqld_server","libmysqld_client", NULL };
mysql_library_init(num_elements, server_options, server_groups);
mysql = mysql_init(NULL);
mysql_options(mysql, MYSQL_READ_DEFAULT_GROUP, "libmysqld_client");
mysql_options(mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, NULL);
if(!mysql_real_connect(mysql,NULL ,NULL, NULL,"C:\Program Files\Borland\CBuilder6\Projects\soft_diete\datadir\testemb", 0,NULL,0))
{
Application->MessageBox("connection a échoué", "echoue", MB_OK);
Edit1->Text= mysql_error(mysql);
}
else
{
Application->MessageBox("connection a reussi", "reussi", MB_OK);
Edit1->Text="";
mysql_real_query(mysql,"CREATE TABLE table_name (nom VARCHAR(20))",42);
Edit1->Text= mysql_error(mysql);
}
mysql_free_result(results);
mysql_close(mysql);
mysql_library_end(); |
