mysql_init() initialization problem

[Chinmay Shah]

hi,
when i try to call the mysql_init function it is not getting initilized properly.
can someone help me

thanks
chinmay

[Chinmay Shah]

sh*********@gmail.com (Chinmay Shah) wrote in message news:<d9**************************@posting.google. com>...

hi,
can someone help me pleaseeeeee? i am attempting to connect mysql server to win32 application... as far
as initialization is concerned, it is successful but its showing some
problem when i use mysql_real_connect..... have used different
combinations to try and connect but all are unsuccessful... here is
the code which i have written.... is there any mistake in the code...
do let me know??????

the code is:

#include<winsock.h>
#include<my_global.h>
#include<mysql.h>
#include<windows.h>
#include<windowsx.h>

void ConnectToMySql()
{
MYSQL mysql;

char *mysql_host = "localhost";
char *mysql_user = "root";
char *mysql_pass = "";
char *mysql_db = "test";
int mysql_port = 3306;
int mysql_flag = 0;
char *mysql_unix = NULL;

//Allocates or initializes a MYSQL object
if(mysql_init(&mysql))
MessageBox(g_hWnd,"Initialization Successful","Testing",0);
else
MessageBox(g_hWnd,"Initialization Not Successful","Testing",0);

//attempts to establish a connection to a MySQL database engine
running on host
if(!mysql_real_connect
(&mysql,MYSQL_HOST,MYSQL_USER,MYSQL_PASSWORD,MYSQL _DB,MYSQL_PORT,MYSQL_SOCKET,MYSQL_FLAG))
MessageBox(g_hWnd,"Connection 1 Not Successful","Test",0);

if(!mysql_real_connect(&mysql,mysql_host,mysql_use r,mysql_pass,mysql_db,mysql_port,mysql_unix,mysql_ flag))
MessageBox(g_hWnd,"Connection 2 Not Successful","Test",0);

if(!mysql_real_connect(&mysql,"localhost","root"," ","test",3306,NULL,0))
MessageBox(g_hWnd,"Connection 3 Not Successful","Test",0);

if(!mysql_real_connect(&mysql,"localhost","","","" ,0,NULL,0))
MessageBox(g_hWnd,"Connection 4 Not Successful","Test",0);

if(!mysql_real_connect(&mysql,"localhost","root"," ","test",0,NULL,0))
MessageBox(g_hWnd,"Connection 5 Not Successful","Test",0);

if(!mysql_real_connect(&mysql,"","","","",0,NULL,0 ))
MessageBox(g_hWnd,"Connection 6 Not Successful","Test",0);

if(!mysql_real_connect(&mysql,"localhost","root"," ","",0,NULL,0))
MessageBox(g_hWnd,"Connection 7 Not Successful","Test",0);
}
do let me at the earliest...
thanks
chinmay