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

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

Postby Marc Vanzegbroeck » Sat Aug 04, 2012 12:05 pm

Richard,

Thank you,
I received it.

Marc
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Marc Vanzegbroeck
 
Posts: 1159
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium

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

Postby mosh1 » Sun Aug 05, 2012 2:41 pm

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
mosh1
 
Posts: 129
Joined: Sun Oct 09, 2011 3:50 pm

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

Postby Marc Vanzegbroeck » Sun Aug 05, 2012 6:40 pm

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
Marc Vanzegbroeck
 
Posts: 1159
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium

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

Postby mosh1 » Sun Aug 05, 2012 7:55 pm

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
mosh1
 
Posts: 129
Joined: Sun Oct 09, 2011 3:50 pm

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

Postby Marc Vanzegbroeck » Sun Aug 05, 2012 8:08 pm

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
Marc Vanzegbroeck
 
Posts: 1159
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium

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

Postby mosh1 » Sun Aug 05, 2012 8:36 pm

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?
mosh1
 
Posts: 129
Joined: Sun Oct 09, 2011 3:50 pm

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

Postby richard-service » Mon Aug 06, 2012 2:54 am

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.
Best Regards,

Richard

Harbour 3.2.0dev (r2402101027) => Borland C++ v7.7 32bit
MySQL v8.0 /ADS v10
Harbour 3.2.0dev (r2011030937) => Borland C++ v7.4 64bit
User avatar
richard-service
 
Posts: 803
Joined: Tue Oct 16, 2007 8:57 am
Location: New Taipei City, Taiwan

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

Postby Marc Vanzegbroeck » Mon Aug 06, 2012 6:55 am

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
Marc Vanzegbroeck
 
Posts: 1159
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium

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

Postby mosh1 » Mon Aug 06, 2012 6:49 pm

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?
mosh1
 
Posts: 129
Joined: Sun Oct 09, 2011 3:50 pm

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

Postby Marc Vanzegbroeck » Mon Aug 06, 2012 9:12 pm

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
Marc Vanzegbroeck
 
Posts: 1159
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium

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

Postby mosh1 » Mon Aug 06, 2012 10:11 pm

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
mosh1
 
Posts: 129
Joined: Sun Oct 09, 2011 3:50 pm

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

Postby Daniel Garcia-Gil » Tue Aug 07, 2012 1:27 am

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.
User avatar
Daniel Garcia-Gil
 
Posts: 2365
Joined: Wed Nov 02, 2005 11:46 pm
Location: Isla de Margarita

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

Postby ADutheil » Tue Aug 07, 2012 10:55 am

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 + MSVS 10
ADutheil
 
Posts: 368
Joined: Sun May 31, 2009 6:25 pm
Location: Salvador - Bahia - Brazil

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

Postby mosh1 » Tue Aug 07, 2012 3:55 pm

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

Postby mosh1 » Thu Aug 09, 2012 8:18 pm

richard-service wrote:I sent it.


Can you please send me whatever is in :

p:\drlib32x\include\

Thanks
mosh1
 
Posts: 129
Joined: Sun Oct 09, 2011 3:50 pm

PreviousNext

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 94 guests