FiveTech Software tech support forums

linking...
ld: Undefined symbols:
_HB_FUN_MARIA_CONNECT, referenced from:
_symbols_table in testdlg.o
clang: error: linker command failed with exit code 1 (use -v to see invocation)
done!
The application cannot be opened for an unexpected reason, error=Error Domain=NSOSStatusErrorDomain Code=-10827 "kLSNoExecutableErr: The executable is missing" UserInfo={_LSLine=4129, _LSFunction=_LSOpenStuffCallLocal}

Code: Select all  Expand view

function conectarse()
  local cUsuario
  local cPassword
  local cDb
  local cHost
  local oCnx

  cUsuario:= 'usrpruebamac'
  cPassword:= 'Gales199452012'
  cDb:= 'dbpruebamac'
  cHost:= '127.0.0.1'

  oCnx:= maria_connect({cHost, cDb, cUsuario, cPassword})
 
return (nil)

gcc $OBJ/$1.o -o ./$1.app/Contents/MacOS/$1 -L$CRTLIB -L$FIVEMAC/lib -lfive -lfivec -L$HARBOUR/lib/darwin/clang $HRBLIBS $FRAMEWORKS -F$FIVEMAC/frameworks -framework Scintilla $CRTLIB/libz.tbd $CRTLIB/libpcre.tbd

Install MySQL Connector/C:
Make sure you have MySQL Connector/C installed on your macOS. You can download it from the official MySQL website: https://dev.mysql.com/downloads/connector/c/

#include <stdio.h>
#include <stdlib.h>
#include <mysql/mysql.h>

int main() {
MYSQL *conn;
MYSQL_RES *res;
MYSQL_ROW row;

// Initialize the MySQL connection
conn = mysql_init(NULL);

// Replace these with your MySQL server details
const char *host = "localhost";
const char *user = "your_username";
const char *password = "your_password";
const char *database = "your_database";

// Connect to MySQL
if (mysql_real_connect(conn, host, user, password, database, 0, NULL, 0) == NULL) {
fprintf(stderr, "Error connecting to MySQL: %s\n", mysql_error(conn));
mysql_close(conn);
exit(EXIT_FAILURE);
}

// Execute a simple query
if (mysql_query(conn, "SELECT * FROM your_table")) {
fprintf(stderr, "Error querying MySQL: %s\n", mysql_error(conn));
mysql_close(conn);
exit(EXIT_FAILURE);
}

// Get the result set
res = mysql_store_result(conn);

// Process the result set
while ((row = mysql_fetch_row(res)) != NULL) {
printf("%s\t%s\n", row[0], row[1]); // Adjust column indices as needed
}

// Free the result set
mysql_free_result(res);

// Close the MySQL connection
mysql_close(conn);

return EXIT_SUCCESS;
}

gcc your_program.c -o your_program -lmysqlclient