Using functions?

Hi, im trying to make a dll to access a mysql server via VB6.

But im getting the following errors:

Code:

---

Deleting intermediate files and output files for project 'mysql - Win32 Debug'.
--------------------Configuration: mysql - Win32 Debug--------------------
Compiling...
main.cpp
c:\cplusplus projects\mysql\main.cpp(17) : error C2440: 'return' : cannot convert from 'char [17]' to 'char'
        This conversion requires a reinterpret_cast, a C-style cast or function-style cast
c:\cplusplus projects\mysql\main.cpp(23) : error C2440: 'return' : cannot convert from 'char [17]' to 'char'
        This conversion requires a reinterpret_cast, a C-style cast or function-style cast
c:\cplusplus projects\mysql\main.cpp(30) : error C2440: 'return' : cannot convert from 'char ** ' to 'char'
        This conversion requires a reinterpret_cast, a C-style cast or function-style cast
c:\cplusplus projects\mysql\main.cpp(35) : error C2440: 'return' : cannot convert from 'char [18]' to 'char'
        This conversion requires a reinterpret_cast, a C-style cast or function-style cast
Error executing cl.exe.

mysql.dll - 4 error(s), 0 warning(s)

---

This is my code:

Code:

---

#include <winsock.h>
#include <mysql.h>
#include <stdio.h>

char connecttoserver(char *server, char *user, char *password, char *database);
char sendquery(char *query);
char fetchresult();
char closeconn();

  MYSQL *conn;
  MYSQL_RES *res;
  MYSQL_ROW row;

  char connecttoserver(char *server, char *user, char *password, char *database) {
        conn = mysql_init(NULL);
                if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) {
                        return "Error connecting";
                }
  }

  char sendquery(char *query) {
        if (mysql_query(conn, query)) {
                return "Error with query";
        }
  }

  char fetchresult() {
        res = mysql_use_result(conn);
        while ((row = mysql_fetch_row(res)) != NULL)
        return row;
  }

  char closeconn() {
        mysql_close(conn);
        return "Connection closed";
  }

---

Change your char return type to char*

**** i fixed most of it but still havent got it.. im sry for these noobish questions

Code:

---

#include <winsock.h>
#include <mysql.h>
#include <stdio.h>

char* connecttoserver(char *server, char *user, char *password, char *database);
char* sendquery(char *query);
char fetchresult();
char* closeconn();

  MYSQL *conn;
  MYSQL_RES *res;
  MYSQL_ROW row;

  char* connecttoserver(char *server, char *user, char *password, char *database) {
        conn = mysql_init(NULL);
                if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) {
                        return "Error connecting";
                }
  }

  char* sendquery(char *query) {
        if (mysql_query(conn, query)) {
                return "Error with query";
        }
  }

  char fetchresult() {
        res = mysql_use_result(conn);
        while ((row = mysql_fetch_row(res)) != NULL)
        return row;
  }

  char* closeconn() {
        mysql_close(conn);
        return "Connection closed";
  }

---

error:

Code:

---

--------------------Configuration: mysql - Win32 Debug--------------------
Compiling...
main.cpp
C:\CPlusPlus Projects\mysql\main.cpp(30) : error C2440: 'return' : cannot convert from 'char ** ' to 'char'
        This conversion requires a reinterpret_cast, a C-style cast or function-style cast
Error executing cl.exe.

mysql.dll - 1 error(s), 0 warning(s)

---

I keep getting the same error, even if i put char*

row is of type char** so you'd have to change the return type to char** for that one.

Works great :) Thanks so much

Only too bad that there doesnt seem to be any support for fetching arrays like in php

Hmm when i implement it into my vb project, and i try to run my project it says:

Can't find DLL entry point connect in mysql.dll

I implement it this way in vb:

Code:

---

Private Declare Function connect Lib "mysql.dll" (server, user, password, database)
Private Declare Function query Lib "mysql.dll" (query)
Private Declare Function fetch_row Lib "mysql.dll" ()
Private Declare Function closeconn Lib "mysql.dll" ()

---

The mysql.dll is in the same folder as in the exe that was made by VB

I don't know anything about .dll but I would say that has something to do with a .lib that needs to be linked.

It does say "LINK : warning LNK4089: all references to "LIBMYSQL.dll" discarded by /OPT:REF" when it compiles it.
Thats the release compile. But when i compile under "debug" it doesnt give an error, but it doesnt even find it when i try to access it with vb

When you downloaded the mySQL libraries did it come with a mysql.lib? That's an import library. From what I know, it basically tells the program where to look in the DLL to get the stuff it needs. It needs to be in the project when you compile.

I have all the necessery links made, ive even successfully tested its functions in a c++ program. The only thing i now need is for the dll to work.
Do i need to put constructors and destructors and all of those things in a dll project?

no, you need to link against the lib file which either comes with the dll or can be generated using something like implib.
After that, the OS kernel should take care of things at runtime.

Ive found the problem:
The problem was in my vb code, i had the wrong function names declared, sorry, that was stupid, but now i face another problem.
When i try to use a function, my program just ends. And if i try to run it in the VB environment itself, it closes down visual basic. While there is no single code of ending the program, not in the DLL nor exe.

Segementation fault? Your OS clearly doesn't like something your doing in the program.

A segmentation fault is when your program accesses memory that doesn't belong to it. You can use a debugger/cout statements to find out where it seg faults.

Oh, I wasn't asking. That "Segmentation fault?" was meant to be read as "Maybe it's a segmentation fault" hence the reason the program is crashing abruptly, aye.

I know. I wasn't explaining what it was to you.

Ive managed to debug it a little, and it doesnt seem to be the cause of my own dll, but the dll MY dll is based on:

http://users.skynet.be/fa321669/VC++ mysqldllerror.JPG

Ive been doing some searching in the msdn files and i found that to enable C++ dlls to be used in VB, i need to add __stdcall in front of the function(in VC++). I tried this, but it did not help.

EDIT: sry, removed the vb code

Quote:

---

This is my VB Code:

---

Are you aware that this is a C++ forum?

Hmm i actually got it to work. I can now connect through a VB6 project :)

But i still cant send a query, it still crashes when i try to send a query, but it also crashes within a C++ project, so i think its a problem with my function. Also, it does not seem to return the "returns" in my VB project. And it also shows an error after i close the VB program after i use the connect function.

This is my code:

Code:

---

#include "stdafx.h"
#include <winsock.h>
#include <mysql.h>

BOOL APIENTRY DllMain( HANDLE hModule,
                      DWORD  ul_reason_for_call,
                      LPVOID lpReserved
                                        )
{
    return TRUE;
}

char* __stdcall mysql_connect(char *server, char *user, char *password, char *database);
char* __stdcall mysql_sendquery(char *query);
char** __stdcall mysql_fetch_row();
char* __stdcall mysql_closeconn();

  MYSQL *conn;
  MYSQL_RES *res;
  MYSQL_ROW row;

  char* __stdcall mysql_connect(char *server, char *user, char *password, char *database) {
        conn = mysql_init(NULL);
                if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) {
                        return "Error connecting";
                }
        return "Connected";
  }

  char* __stdcall mysql_sendquery(char *query) {
        if (mysql_query(conn, query)) {
                return "Error with query";
        }
        return "Query successfull";
  }

  char** __stdcall mysql_fetch_row() {
        char** error;
        error[1] = "Error fetching row";
        res = mysql_use_result(conn);
        while ((row = mysql_fetch_row(res)) != NULL) {
        return row;
        }
        return error;
  }

  char* __stdcall mysql_closeconn() {
        mysql_close(conn);
        return "Connection closed";
  }

---