FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour What is the best of MySql (lib or class) TMySql, TDolphin
ShumingWang
Posts: 474
Joined: Sun Oct 30, 2005 06:37 AM
Re: What is the best of MySql (lib or class) TMySql, TDolphin
Posted: Mon Jul 09, 2012 03:20 AM

Tmysql:
1. http://harbour-project.svn.sourceforge. ... b/hbmysql/
2. http://www.xtech.com.cn/down/tmysql.prg

http://www.xtech.com.cn/down/mysql.c

http://www.xtech.com.cn/down/mysql.ch

http://www.xtech.com.cn/down/mysql.h

http://www.xtech.com.cn/down/sample1.prg

http://www.xtech.com.cn/down/sample2.prg

http://www.xtech2.top
Mobile:(86)13802729058
Email:100200651@qq.com
QQ:100200651
Weixin: qq100200651
Marc Vanzegbroeck
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: What is the best of MySql (lib or class) TMySql, TDolphin
Posted: Mon Jul 09, 2012 05:36 AM

Hi,

Can Tmysql still work with the old xHarbour-compiler 0.99.71 (Simplex)?
I have tried TDolphin, but some commands are not recognized by the compiler, and after changing them, I still have missing functions after trying to build an example.

Regards,
Marc

Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
lucasdebeltran
Posts: 1303
Joined: Tue Jul 21, 2009 08:12 AM
Re: What is the best of MySql (lib or class) TMySql, TDolphin
Posted: Mon Jul 09, 2012 08:15 AM

Hi,

TMysql,TDolphin or ADO yes, they are perfect options from a new application.

The problem is preexistings apps, it is very hard to rewrite all code.

Also, for a single PC I think it does not worth to use Mysql (set up problems, bakcups...).

That´s because I think an RDD for SQL es so important for us ;).

Muchas gracias. Many thanks.



Un saludo, Best regards,



Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]



Implementando MSVC 2010, FWH64 y ADO.



Abandonando uso xHarbour y SQLRDD.
mosh1
Posts: 129
Joined: Sun Oct 09, 2011 03:50 PM
Re: What is the best of MySql (lib or class) TMySql, TDolphin
Posted: Mon Jul 09, 2012 10:33 PM
ShumingWang wrote:Tmysql:
1. http://harbour-project.svn.sourceforge. ... b/hbmysql/
2. http://www.xtech.com.cn/down/tmysql.prg
http://www.xtech.com.cn/down/mysql.c
http://www.xtech.com.cn/down/mysql.ch


Cannot compile. One of many errors : mysql.h is missing
ShumingWang
Posts: 474
Joined: Sun Oct 30, 2005 06:37 AM
Re: What is the best of MySql (lib or class) TMySql, TDolphin
Posted: Tue Jul 10, 2012 02:20 AM

www.xtech.com.cn/down/mysql.h

http://www.xtech2.top
Mobile:(86)13802729058
Email:100200651@qq.com
QQ:100200651
Weixin: qq100200651
mosh1
Posts: 129
Joined: Sun Oct 09, 2011 03:50 PM
Re: What is the best of MySql (lib or class) TMySql, TDolphin
Posted: Tue Jul 10, 2012 04:39 AM
ShumingWang wrote:http://www.xtech.com.cn/down/mysql.h

Thanks!

Now I get the following errors :

Error E2209 mysql.h 57: Unable to open include file 'mysql_com.h'
Error E2209 mysql.h 58: Unable to open include file 'mysql_version.h'
Error E2209 mysql.h 59: Unable to open include file 'typelib.h'
Error E2209 mysql.h 64: Unable to open include file 'my_list.h'
Error E2209 mysql.h 128: Unable to open include file 'my_alloc.h'
ShumingWang
Posts: 474
Joined: Sun Oct 30, 2005 06:37 AM
Re: What is the best of MySql (lib or class) TMySql, TDolphin
Posted: Tue Jul 10, 2012 05:16 AM

download http://dev.mysql.com/downloads/connector/c/
and set path or copy include to mysql.c folder

http://www.xtech2.top
Mobile:(86)13802729058
Email:100200651@qq.com
QQ:100200651
Weixin: qq100200651
mosh1
Posts: 129
Joined: Sun Oct 09, 2011 03:50 PM
Re: What is the best of MySql (lib or class) TMySql, TDolphin
Posted: Tue Jul 10, 2012 05:38 AM
ShumingWang wrote:download http://dev.mysql.com/downloads/connector/c/
and set path or copy include to mysql.c folder


Now I get these errors :

c:\Borland\bcc582\bin\bcc32 -M -c -v -w -Ic:\Borland\bcc582\include -Ic:\xharbour\include -I"C:\Program Files\MySQL\MySQL Connector C 6.0.2\include" -I.\include MYSQL.c
Borland C++ 5.82 for Win32 Copyright (c) 1993, 2005 Borland
MYSQL.C:
Error E2139 C:\Program Files\MySQL\MySQL Connector C 6.0.2\include\mysql_com.h 268: Declaration missing ;
Error E2147 C:\Program Files\MySQL\MySQL Connector C 6.0.2\include\mysql_com.h 437: 'SOCKET' cannot start a parameter declaration
Error E2141 C:\Program Files\MySQL\MySQL Connector C 6.0.2\include\typelib.h 29: Declaration syntax error
Error E2238 mysql.h 113: Multiple declaration for 'my_ulonglong'
Error E2344 C:\Program Files\MySQL\MySQL Connector C 6.0.2\include\typelib.h 29: Earlier declaration of 'my_ulonglong'
Warning W8075 MYSQL.C 324: Suspicious pointer conversion in function HB_FUN_SQLLISTTBL
Warning W8079 MYSQL.C 384: Mixing pointers to different 'char' types in function filetoBuff
Warning W8075 MYSQL.C 402: Suspicious pointer conversion in function HB_FUN_FILETOSQLBINARY
*** 5 errors in Compile ***
ShumingWang
Posts: 474
Joined: Sun Oct 30, 2005 06:37 AM
Re: What is the best of MySql (lib or class) TMySql, TDolphin
Posted: Tue Jul 10, 2012 06:40 AM

Oh, I use harbour 3.0
try http://www.xtech.com.cn/down/include.rar

http://www.xtech2.top
Mobile:(86)13802729058
Email:100200651@qq.com
QQ:100200651
Weixin: qq100200651
mosh1
Posts: 129
Joined: Sun Oct 09, 2011 03:50 PM
Re: What is the best of MySql (lib or class) TMySql, TDolphin
Posted: Tue Jul 10, 2012 02:44 PM
ShumingWang wrote:Oh, I use harbour 3.0
try http://www.xtech.com.cn/down/include.rar


Now I have only 2 errors :

c:\Borland\bcc582\bin\bcc32 -M -c -v -w -Ic:\Borland\bcc582\include -Ic:\xharbour\include -I.\include MYSQL.c
Borland C++ 5.82 for Win32 Copyright (c) 1993, 2005 Borland
MYSQL.C:
Error E2139 .\include\mysql_com.h 183: Declaration missing ;
Error E2147 .\include\mysql_com.h 358: 'SOCKET' cannot start a parameter declaration
Warning W8075 MYSQL.C 324: Suspicious pointer conversion in function HB_FUN_SQLLISTTBL
Warning W8079 MYSQL.C 384: Mixing pointers to different 'char' types in function filetoBuff
Warning W8075 MYSQL.C 402: Suspicious pointer conversion in function HB_FUN_FILETOSQLBINARY
*** 2 errors in Compile ***
ShumingWang
Posts: 474
Joined: Sun Oct 30, 2005 06:37 AM
Re: What is the best of MySql (lib or class) TMySql, TDolphin
Posted: Wed Jul 11, 2012 01:38 AM

Sorry I do not use xharbour, nor understand C.

http://www.xtech2.top
Mobile:(86)13802729058
Email:100200651@qq.com
QQ:100200651
Weixin: qq100200651
mosh1
Posts: 129
Joined: Sun Oct 09, 2011 03:50 PM
Re: What is the best of MySql (lib or class) TMySql, TDolphin
Posted: Wed Jul 11, 2012 02:37 AM
ShumingWang wrote:Sorry I do not use xharbour, nor understand C.


Thanks anyway. Can anyone help me to compile mysql ?
ShumingWang
Posts: 474
Joined: Sun Oct 30, 2005 06:37 AM
Re: What is the best of MySql (lib or class) TMySql, TDolphin
Posted: Wed Jul 11, 2012 09:13 AM

I downloaded http://dev.mysql.com/downloads/connector/c/ version win32-vs2005 ,
rebuild mysql.c -->mysql.obj, then mysql.lib, no warrnings .
Habour 3.0 ,Bcc55 ,fwh1104 .

Regards !
Shuming Wang

http://www.xtech2.top
Mobile:(86)13802729058
Email:100200651@qq.com
QQ:100200651
Weixin: qq100200651
mosh1
Posts: 129
Joined: Sun Oct 09, 2011 03:50 PM
Re: What is the best of MySql (lib or class) TMySql, TDolphin
Posted: Wed Jul 11, 2012 02:15 PM
ShumingWang wrote:I downloaded http://dev.mysql.com/downloads/connector/c/ version win32-vs2005 ,
rebuild mysql.c -->mysql.obj, then mysql.lib, no warrnings .
Habour 3.0 ,Bcc55 ,fwh1104 .

Regards !
Shuming Wang


Can you please post details how you rebuild? Thanks
ShumingWang
Posts: 474
Joined: Sun Oct 30, 2005 06:37 AM
Re: What is the best of MySql (lib or class) TMySql, TDolphin
Posted: Thu Jul 12, 2012 10:29 AM

Sorry my mistakes.

but http://www.xtech.com.cn/down/include.rar with bcc55,bcc582 works.

//---------------------
makefile.bc :

INCLUDE_DIR = d:\borland\bcc55\include;d:\harbour30\include;d:\mysqlinclude

BIN_DIR = d:\harbour30\bin
OBJ_DIR = obj
LIB_DIR = lib

$(LIB_DIR)\mysql.lib :\
$(OBJ_DIR)\tmysql.obj \
$(OBJ_DIR)\mysql.obj

$(OBJ_DIR)\tmysql.c : tmysql.prg
$(OBJ_DIR)\tmysql.obj : $(OBJ_DIR)\tmysql.c
$(OBJ_DIR)\mysql.obj : mysql.c

.c.obj:
\borland\bcc55\bin\bcc32 $(CLIBFLAGS) -c -O2 -I$(INCLUDE_DIR) -DHB_OS_WIN_32_USED -o$@ $<
\borland\bcc55\bin\tlib $(LIB_DIR)\mysql.lib -+$@,,

.prg.c:
$(BIN_DIR)\harbour.exe $< -q0 -w -es2 -gc0 -n -i$(INCLUDE_DIR) -o$@

//-----------------------------
make_b32.bat:
@echo off
rem
rem $Id: make_b32.bat,v 1.1 2003/02/03 05:19:18 walito Exp $
rem
if "%1" == "clean" goto CLEAN
if "%1" == "CLEAN" goto CLEAN
:BUILD
D:\borland\bcc55\bin\make -fmakefile.bc %1 %2 %3 > make_b32.log
if errorlevel 1 goto BUILD_ERR
:BUILD_OK
copy lib\mysql.lib . > nul
goto EXIT
:BUILD_ERR
notepad make_b32.log
goto EXIT
:CLEAN
if exist lib\mysql.lib del lib\mysql.lib
if exist lib\mysql.bak del lib\mysql.bak
if exist obj\mysql.obj del obj\mysql.obj
if exist obj\tmysql.c del obj\tmysql.c
if exist obj\tmysql.obj del obj\tmysql.obj
goto EXIT
:EXIT

http://www.xtech2.top
Mobile:(86)13802729058
Email:100200651@qq.com
QQ:100200651
Weixin: qq100200651
Static archive · New replies & topics via GitHub Discussions