What is the best of MySql (lib or class) TMySql, TDolphin

Marc Vanzegbroeck
Posts: 1102
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium
Contact:

Re: What is the best of MySql (lib or class) TMySql, TDolphin

Post by Marc Vanzegbroeck »

Richard,

Thank you,
I received it.

Marc
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
mosh1
Posts: 129
Joined: Sun Oct 09, 2011 3:50 pm

Re: What is the best of MySql (lib or class) TMySql, TDolphin

Post by mosh1 »

I get it thanks!

MAKE Version 5.2 Copyright (c) 1987, 2000 Borland
C:\borland\bcc582\bin\bcc32 -c -O2 -IC:\borland\bcc582\include;c:\hb30\include -DHB_OS_WIN_32_USED -oobj\tmysql.obj obj\tmysql.c
Borland C++ 5.82 for Win32 Copyright (c) 1993, 2005 Borland
obj\tmysql.c:
Error E2451 obj\tmysql.c 142: Undefined symbol 'ModuleFakeDyn'
Error E2141 obj\tmysql.c 142: Declaration syntax error
Error E2190 obj\tmysql.c 142: Unexpected }
Error E2040 obj\tmysql.c 142: Declaration terminated incorrectly
Error E2190 obj\tmysql.c 334: Unexpected }
Error E2109 obj\tmysql.c 334: Not an allowed type in function hb_vm_SymbolInit_TMYSQL
*** 6 errors in Compile ***

** error 1 ** deleting obj\tmysql.obj
Marc Vanzegbroeck
Posts: 1102
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium
Contact:

Re: What is the best of MySql (lib or class) TMySql, TDolphin

Post by Marc Vanzegbroeck »

Richard,

For me it's running fine. I can connect to my SQL-server (MariaDB) an create database and tables.

The only thing I could find is how to run in embedded mode (no MySQL-server or MariaDB running) for no network version, and development.
But this is noo problem. Now I'm using SQLite for that.

Regards,
Marc
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
mosh1
Posts: 129
Joined: Sun Oct 09, 2011 3:50 pm

Re: What is the best of MySql (lib or class) TMySql, TDolphin

Post by mosh1 »

Marc Vanzegbroeck wrote:Richard,

For me it's running fine.
Marc
Marc, do you use Harbour or xHarbour? And can you please post your link file too
Thanks
Marc Vanzegbroeck
Posts: 1102
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium
Contact:

Re: What is the best of MySql (lib or class) TMySql, TDolphin

Post by Marc Vanzegbroeck »

mosh1 wrote:
Marc Vanzegbroeck wrote:Richard,

For me it's running fine.
Marc
Marc, do you use Harbour or xHarbour? And can you please post your link file too
Thanks
I'm using xHarbour 0.99.71 (Simplex)
I'm using Richard files to create the lib-files

Marc
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
mosh1
Posts: 129
Joined: Sun Oct 09, 2011 3:50 pm

Re: What is the best of MySql (lib or class) TMySql, TDolphin

Post by mosh1 »

Marc Vanzegbroeck wrote:
mosh1 wrote:
Marc Vanzegbroeck wrote:Richard,

For me it's running fine.
Marc
Marc, do you use Harbour or xHarbour? And can you please post your link file too
Thanks
I'm using xHarbour 0.99.71 (Simplex)
I'm using Richard files to create the lib-files

Marc
And how do you link your samples?
User avatar
richard-service
Posts: 583
Joined: Tue Oct 16, 2007 8:57 am
Location: New Taipei City, Taiwan
Contact:

Re: What is the best of MySql (lib or class) TMySql, TDolphin

Post by richard-service »

Marc Vanzegbroeck wrote:Richard,

For me it's running fine. I can connect to my SQL-server (MariaDB) an create database and tables.

The only thing I could find is how to run in embedded mode (no MySQL-server or MariaDB running) for no network version, and development.
But this is noo problem. Now I'm using SQLite for that.

Regards,
Marc
Now, I Only use MySQL Server v5.5 within my NB Windows8. You can use Local Host way to connect MySQL Server.
Regards,

Richard

Harbour 3.2.0dev (r1904111533)/xHarbour 1.2.3 Intl. (SimpLex) (Build 20180818) => Borland C++ v7.4
xHarbour 0.99.71 (SimpLex) => Borland C++ v5.5
MySQL v5.7 /ADS v12
Harbour 3.2.0dev (r1603181642) => Borland C++ v7.4 64bit
Marc Vanzegbroeck
Posts: 1102
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium
Contact:

Re: What is the best of MySql (lib or class) TMySql, TDolphin

Post by Marc Vanzegbroeck »

mosh1 wrote:
And how do you link your samples?
I added these 2 lines
C:\FWH\MySQL\TMySQL\mysql.lib +
C:\FWH\MySQL\TMySQL\libmysql.lib +
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
mosh1
Posts: 129
Joined: Sun Oct 09, 2011 3:50 pm

Re: What is the best of MySql (lib or class) TMySql, TDolphin

Post by mosh1 »

Marc Vanzegbroeck wrote:
mosh1 wrote:
And how do you link your samples?
I added these 2 lines
C:\FWH\MySQL\TMySQL\mysql.lib +
C:\FWH\MySQL\TMySQL\libmysql.lib +
Thanks! I compiled and linked test.prg samples and now I am getting "No connection to server" message. What can be wrong?

Also : is it possible to use Harbour not xHarbour?
Marc Vanzegbroeck
Posts: 1102
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium
Contact:

Re: What is the best of MySql (lib or class) TMySql, TDolphin

Post by Marc Vanzegbroeck »

mosh1 wrote:
Marc Vanzegbroeck wrote:
mosh1 wrote:
And how do you link your samples?
I added these 2 lines
C:\FWH\MySQL\TMySQL\mysql.lib +
C:\FWH\MySQL\TMySQL\libmysql.lib +
Thanks! I compiled and linked test.prg samples and now I am getting "No connection to server" message. What can be wrong?

Also : is it possible to use Harbour not xHarbour?
Did you set the correct IP-adres,user and password to the server with MySQL?
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
mosh1
Posts: 129
Joined: Sun Oct 09, 2011 3:50 pm

Re: What is the best of MySql (lib or class) TMySql, TDolphin

Post by mosh1 »

Marc Vanzegbroeck wrote: Did you set the correct IP-adres,user and password to the server with MySQL?
Where I have to set IP address and where do I get it?

This is line I am using :

oServer := TMySQLServer():New( "localhost", "root", "password" )

I am sure password is right. MySQL server is on the same machine
User avatar
Daniel Garcia-Gil
Posts: 2365
Joined: Wed Nov 02, 2005 11:46 pm
Location: Isla de Margarita
Contact:

Re: What is the best of MySql (lib or class) TMySql, TDolphin

Post by Daniel Garcia-Gil »

Hello

instead localhost use 127.0.0.1

sometimes this problem occurs because the mysql imported lib (libmysql.lib) was not corresponds with current DLL (libmysql.dll)
you can use implib.exe tool (from borland) to built it.
our best documentation is the source code
Isla de Margarita Venezuela.
danielgarciagil@gmail.com
http://tdolphin.blogspot.com/
https://www.dropbox.com/referrals/NTI5N ... rc=global9
ADutheil
Posts: 352
Joined: Sun May 31, 2009 6:25 pm
Location: Salvador - Bahia - Brazil

Re: What is the best of MySql (lib or class) TMySql, TDolphin

Post by ADutheil »

mosh1 wrote: Thanks! I compiled and linked test.prg samples and now I am getting "No connection to server" message. What can be wrong?
If your MySQL database is on another computer you should check the my.cnf to see if network connections are allowed and configure your firewall to accept TCP connections on port 3306.
Regards,

André Dutheil
FWH 13.04 HB 3.2 BCC 5.82 MinGW 4.5.2 MSVS 10
mosh1
Posts: 129
Joined: Sun Oct 09, 2011 3:50 pm

Re: What is the best of MySql (lib or class) TMySql, TDolphin

Post by mosh1 »

Daniel Garcia-Gil wrote:Hello

instead localhost use 127.0.0.1

sometimes this problem occurs because the mysql imported lib (libmysql.lib) was not corresponds with current DLL (libmysql.dll)
you can use implib.exe tool (from borland) to built it.
Thanks! 127.0.0.1 works, but I built libmysql.lib with implib.exe from Borland and localhost still is not accepted.
mosh1
Posts: 129
Joined: Sun Oct 09, 2011 3:50 pm

Re: What is the best of MySql (lib or class) TMySql, TDolphin

Post by mosh1 »

richard-service wrote: I sent it.
Can you please send me whatever is in :

p:\drlib32x\include\

Thanks
Post Reply