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

[ShumingWang]

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

[Marc Vanzegbroeck]

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

[lucasdebeltran]

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 .

[mosh1]

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]

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

[mosh1]

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]

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

[mosh1]

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]

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

[mosh1]

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]

Sorry I do not use xharbour, nor understand C.

[mosh1]

Sorry I do not use xharbour, nor understand C.

Thanks anyway. Can anyone help me to compile mysql ?

[ShumingWang]

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

[mosh1]

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]

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