Page 4 of 7

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

Posted: Sat Aug 04, 2012 12:05 pm
by Marc Vanzegbroeck
Richard,

Thank you,
I received it.

Marc

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

Posted: Sun Aug 05, 2012 2:41 pm
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

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

Posted: Sun Aug 05, 2012 6:40 pm
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

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

Posted: Sun Aug 05, 2012 7:55 pm
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

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

Posted: Sun Aug 05, 2012 8:08 pm
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

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

Posted: Sun Aug 05, 2012 8:36 pm
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?

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

Posted: Mon Aug 06, 2012 2:54 am
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.

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

Posted: Mon Aug 06, 2012 6:55 am
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 +

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

Posted: Mon Aug 06, 2012 6:49 pm
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?

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

Posted: Mon Aug 06, 2012 9:12 pm
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?

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

Posted: Mon Aug 06, 2012 10:11 pm
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

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

Posted: Tue Aug 07, 2012 1:27 am
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.

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

Posted: Tue Aug 07, 2012 10:55 am
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.

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

Posted: Tue Aug 07, 2012 3:55 pm
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.

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

Posted: Thu Aug 09, 2012 8:18 pm
by mosh1
richard-service wrote:I sent it.


Can you please send me whatever is in :

p:\drlib32x\include\

Thanks