Borland C++ and MySQL connection problem

[arrow]

Hi everybody;

I am trying to connect to MySQL server over MySQL ODBC 3.51 driver. Borland C++ 5.02 is the tool I use.

I tried a simple connection code below:

#include <stdio.h>
#include <stdlib.h>
#include "mysql.h"
 
MYSQL mysql;
int dum;
 
int main()
{
    mysql_init(NULL);
 
    if (!(mysql_real_connect(&mysql,"localhost","onur","pass","mysql",0,NULL,0)))
    {
        printf("Connection failed.");
        scanf(" %d",dum);
    }
    else
    {
        printf("Connected.");
        scanf(" %d",dum);
    }
 
    mysql_close(&mysql);
    return 0;
}

There are three errors with this code:

mysql_com.h( 184, 15 ) : Type name expected
mysql_com.h( 184, 15 ) : Declaration missing ;
mysql_com.h( 354, 26 ) : 'SOCKET' cannot start a parameter declaration

Could anyone help me?
Thanks in advance.

[willakawill]

There are three errors with this code:

mysql_com.h( 184, 15 ) : Type name expected
mysql_com.h( 184, 15 ) : Declaration missing ;
mysql_com.h( 354, 26 ) : 'SOCKET' cannot start a parameter declaration

Could anyone help me?
Thanks in advance.

Hi. The file with the errors, mysql_com.h would not normally contain a main function. Is this the file that you have posted above?

[arrow]

Hi. The file with the errors, mysql_com.h would not normally contain a main function. Is this the file that you have posted above?

No. The code I wrote is not the header file. "mysql_com.h" is called in "mysql.h" automatically.
This problem was solved by including "winsock2.h" header file. Now there are no compile time errors. However there are three linking time errors with MySQL api::

Error: Unresolved external 'mysql_init' referenced from C:\BC5\BIN\MYSQLAPI.OBJ
Error: Unresolved external 'mysql_real_connect' referenced from C:\BC5\BIN\MYSQLAPI.OBJ
Error: Unresolved external 'mysql_close' referenced from C:\BC5\BIN\MYSQLAPI.OBJ

I will try to connect by using the Borland's ODBC functions, not with MySQL api. But I wonder how to solve these linking errors.

Thank you for your interest.

Onur

[litendian]

No. The code I wrote is not the header file. "mysql_com.h" is called in "mysql.h" automatically.
This problem was solved by including "winsock2.h" header file. Now there are no compile time errors. However there are three linking time errors with MySQL api::

Error: Unresolved external 'mysql_init' referenced from C:\BC5\BIN\MYSQLAPI.OBJ
Error: Unresolved external 'mysql_real_connect' referenced from C:\BC5\BIN\MYSQLAPI.OBJ
Error: Unresolved external 'mysql_close' referenced from C:\BC5\BIN\MYSQLAPI.OBJ

I will try to connect by using the Borland's ODBC functions, not with MySQL api. But I wonder how to solve these linking errors.

Thank you for your interest.

Onur

Add libmysql.lib to your project after converting from MS format to Borland format with the command
implib libmysql.lib libmysql.dll