Visualizzazione dei risultati da 1 a 6 su 6
  1. #1

    [C/MySQL] Non riesco a connettermi al database

    Salve a tutti. Uso dev-c++ e ho creato un nuovo progetto C per connettermi al mio database mysql. Nelle opzioni del progetto, ho specificato nelle "Cartelle include", l'indirizzo: C:\mysql\include.

    Questo il codice:

    codice:
    #include <mysql.h>
    #include <stdio.h>
    #include <stdlib.h>
    
    int main(int argc, char *argv[])
    {
      MYSQL *connection;
      MYSQL *res:
      MYSQL *row;
      
      char *host = "localhost";
      char *user = "root";
      char *pass = "";
      char *db = "mysql";
      
      connection = mysql_init (NULL);
      if (!mysql_real_connect (connection, host, user, pass, db, 0, NULL, 0))
      {
         printf ("%s", mysql_error (connection));
         exit (0);
      }
      
      if (mysql_query (connection, "CREATE TABLE IF NOT EXISTS ctest (id INT UNSIGNED NOT NULL auto_increment, value VARCHAR (20), PRIMARY KEY (id))"))
      {
         printf ("%s", mysql_error (connection));
         exit (0);
      }
      
      mysql_free_result (res);
      mysql_close (connection);
      
      system("PAUSE");	
      return 0;
    }
    Ma mi da vari errori quando tento di compilare, ecco il log:
    codice:
    Compilatore: Default compiler
    Building Makefile: "C:\Dev-Cpp\Makefile.win"
    Esecuzione di  make...
    make.exe -f "C:\Dev-Cpp\Makefile.win" all
    gcc.exe -c main.c -o main.o -I"C:/Dev-Cpp/include"  -I"C:/mysql/include"  -I"C:/mysql/include"   
    
    In file included from C:/mysql/include/mysql.h:72,
                     from main.c:1:
    C:/mysql/include/mysql_com.h:183: error: syntax error before "SOCKET"
    C:/mysql/include/mysql_com.h:183: warning: no semicolon at end of struct or union
    C:/mysql/include/mysql_com.h:222: error: syntax error before '}' token
    C:/mysql/include/mysql_com.h:222: warning: data definition has no type or storage class
    
    C:/mysql/include/mysql_com.h:335: error: syntax error before '*' token
    C:/mysql/include/mysql_com.h:336: error: syntax error before '*' token
    
    C:/mysql/include/mysql_com.h:337: error: syntax error before '*' token
    C:/mysql/include/mysql_com.h:338: error: syntax error before '*' token
    
    C:/mysql/include/mysql_com.h:339: error: syntax error before '*' token
    C:/mysql/include/mysql_com.h:340: error: syntax error before '*' token
    
    C:/mysql/include/mysql_com.h:341: error: syntax error before '*' token
    C:/mysql/include/mysql_com.h:342: error: syntax error before '*' token
    
    C:/mysql/include/mysql_com.h:345: error: syntax error before '*' token
    C:/mysql/include/mysql_com.h:346: error: syntax error before '*' token
    
    C:/mysql/include/mysql_com.h:358: error: syntax error before "s"
    In file included from main.c:1:
    C:/mysql/include/mysql.h:257: error: syntax error before "NET"
    C:/mysql/include/mysql.h:257: warning: no semicolon at end of struct or union
    C:/mysql/include/mysql.h:282: error: 'scramble' redeclared as different kind of symbol
    C:/mysql/include/mysql_com.h:426: error: previous declaration of 'scramble' was here
    
    C:/mysql/include/mysql.h:282: error: 'scramble' redeclared as different kind of symbol
    C:/mysql/include/mysql_com.h:426: error: previous declaration of 'scramble' was here
    C:/mysql/include/mysql.h:311: error: syntax error before '}' token
    C:/mysql/include/mysql.h:311: warning: data definition has no type or storage class
    C:/mysql/include/mysql.h:319: error: syntax error before "MYSQL"
    C:/mysql/include/mysql.h:319: warning: no semicolon at end of struct or union
    C:/mysql/include/mysql.h:328: error: syntax error before '}' token
    C:/mysql/include/mysql.h:328: warning: data definition has no type or storage class
    C:/mysql/include/mysql.h:346: error: syntax error before "NET"
    C:/mysql/include/mysql.h:346: warning: no semicolon at end of struct or union
    
    C:/mysql/include/mysql.h:352: error: conflicting types for 'last_errno'
    C:/mysql/include/mysql_com.h:211: error: previous declaration of 'last_errno' was here
    
    C:/mysql/include/mysql.h:355: error: conflicting types for 'last_error'
    C:/mysql/include/mysql_com.h:210: error: previous declaration of 'last_error' was here
    C:/mysql/include/mysql.h:356: error: syntax error before '}' token
    C:/mysql/include/mysql.h:356: warning: data definition has no type or storage class
    C:/mysql/include/mysql.h:404: error: syntax error before '*' token
    C:/mysql/include/mysql.h:405: error: syntax error before '*' token
    C:/mysql/include/mysql.h:406: error: syntax error before '*' token
    C:/mysql/include/mysql.h:407: error: syntax error before '*' token
    C:/mysql/include/mysql.h:409: error: syntax error before '*' token
    C:/mysql/include/mysql.h:410: error: syntax error before '*' token
    C:/mysql/include/mysql.h:411: error: syntax error before '*' token
    
    C:/mysql/include/mysql.h:790: error: syntax error before '*' token
    C:/mysql/include/mysql.h:791: error: syntax error before '*' token
    C:/mysql/include/mysql.h:794: error: syntax error before '*' token
    C:/mysql/include/mysql.h:795: error: syntax error before '*' token
    
    C:/mysql/include/mysql.h:796: error: syntax error before '*' token
    C:/mysql/include/mysql.h:799: error: syntax error before '*' token
    C:/mysql/include/mysql.h:802: error: syntax error before '*' token
    C:/mysql/include/mysql.h:803: error: syntax error before '*' token
    
    C:/mysql/include/mysql.h:804: error: syntax error before '*' token
    C:/mysql/include/mysql.h:805: error: syntax error before '*' token
    C:/mysql/include/mysql.h:806: error: syntax error before '*' token
    C:/mysql/include/mysql.h:807: error: syntax error before '*' token
    
    C:/mysql/include/mysql.h:811: error: syntax error before '*' token
    C:/mysql/include/mysql.h:811: error: syntax error before '*' token
    C:/mysql/include/mysql.h:811: warning: data definition has no type or storage class
    C:/mysql/include/mysql.h:812: error: syntax error before '*' token
    C:/mysql/include/mysql.h:812: error: syntax error before '*' token
    C:/mysql/include/mysql.h:812: warning: data definition has no type or storage class
    C:/mysql/include/mysql.h:813: error: syntax error before '*' token
    C:/mysql/include/mysql.h:814: error: syntax error before '*' token
    C:/mysql/include/mysql.h:815: error: syntax error before '*' token
    C:/mysql/include/mysql.h:816: error: syntax error before '*' token
    C:/mysql/include/mysql.h:818: error: syntax error before '*' token
    C:/mysql/include/mysql.h:819: error: syntax error before '*' token
    C:/mysql/include/mysql.h:820: error: syntax error before '*' token
    C:/mysql/include/mysql.h:821: error: syntax error before '*' token
    C:/mysql/include/mysql.h:822: error: syntax error before '*' token
    C:/mysql/include/mysql.h:823: error: syntax error before '*' token
    C:/mysql/include/mysql.h:825: error: syntax error before '*' token
    C:/mysql/include/mysql.h:826: error: syntax error before '*' token
    C:/mysql/include/mysql.h:827: error: syntax error before '*' token
    C:/mysql/include/mysql.h:828: error: syntax error before '*' token
    C:/mysql/include/mysql.h:829: error: syntax error before '*' token
    C:/mysql/include/mysql.h:830: error: syntax error before '*' token
    main.c: In function `main':
    main.c:7: error: `connection' undeclared (first use in this function)
    main.c:7: error: (Each undeclared identifier is reported only once
    main.c:7: error: for each function it appears in.)
    main.c:8: error: `res' undeclared (first use in this function)
    main.c:8: error: syntax error before ':' token
    
    make.exe: *** [main.o] Error 1
    
    Esecuzione terminata
    (ho accorciato un pò il log altrimenti non riuscivo a postare)
    Qualche idea?

  2. #2

  3. #3
    non è che non si collega al database, non ti compila. Questo è dovuto al fatto che non è definita la variabile __WIN__ e __LCC__, fallo dal tuo ide o dallo come parametro di compilazione
    ciao
    sergio

  4. #4
    Originariamente inviato da mondobimbi
    non è che non si collega al database, non ti compila. Questo è dovuto al fatto che non è definita la variabile __WIN__ e __LCC__, fallo dal tuo ide o dallo come parametro di compilazione
    ciao
    sergio
    Scusa potresti essere un pò più preciso su come settare questi parametri?

  5. #5
    come parametro del compilatore gcc è -Dmacro[=defn]
    Dall'ide dipende da quello che usi, normalmente lo trovi in progetto|opzioni o progette|preferenze .
    ciao
    sergio

  6. #6
    Uso dev-cpp e non riesco a capire come fare leggendo le vostre risposte...

Permessi di invio

  • Non puoi inserire discussioni
  • Non puoi inserire repliche
  • Non puoi inserire allegati
  • Non puoi modificare i tuoi messaggi
  •  
Powered by vBulletin® Version 4.2.1
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved.