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

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

Postby dutch » Sat Feb 25, 2012 12:32 am

Dear All,

I would like to know, the best way to move to MySql?
TMySql (LibMySql)
TDolphin
ADO
etc.

Thanks for all idea and recommendation.

Regards,
Dutch
Regards,
Dutch

FWH 19.01 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio
FWPPC 10.02 / Harbour for PPC (FTDN)
ADS V.9 / MySql / MariaDB
R&R 12 Infinity / Crystal Report XI R2
(Thailand)
User avatar
dutch
 
Posts: 1554
Joined: Fri Oct 07, 2005 5:56 pm
Location: Thailand

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

Postby ShumingWang » Sat Feb 25, 2012 2:42 am

We use Tmysql.prg since 2004, simple,fast,stable!
Only need link libmysql.lib (export from libmysql.dll by tlib.exe) ,mysql.lib (tmysql.prg mysql.c ),running time need libmysql.dll, no other setting on windows nor exe .
Samples : http://www.xtech.com.cn/down/sample1.prg
http://www.xtech.com.cn/down/sample2.prg

Regards!
Shuming wang
http://www.xtech2.top
Mobile:(86)13802729058
Email:100200651@qq.com
QQ:100200651
Weixin: qq100200651
ShumingWang
 
Posts: 465
Joined: Sun Oct 30, 2005 6:37 am
Location: Guangzhou(Canton),China

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

Postby Enrico Maria Giordano » Sat Feb 25, 2012 10:59 am

I use ADO because it is engine aware (ie. I can change database engine without changing my code, only the connection string).

EMG
User avatar
Enrico Maria Giordano
 
Posts: 8725
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia

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

Postby Rick Lipkin » Sat Feb 25, 2012 2:00 pm

I like ADO as well for the very same reason Enrico noted.. and if you are using ado you can specify the cursor location. ( local .. very fast )

Unfortunately ADO for MySql is not native and you have to download ( or pay for .. last time I looked ) a run-time client. If you have plans to distribute your app with ADO and have many computers .. you have a distribution problem.

On the flip side, you can use the MySql library that you can ( conveniently ) link into your app ( much like advantage database ) but the syntax is nothing like the standard ADO methodology which is consistent with Sql Server, Oracle, IBM DB2, Access ..

Pros and cons both ways.

Rick Lipkin
User avatar
Rick Lipkin
 
Posts: 2666
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA

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

Postby csincuir » Sat Feb 25, 2012 2:46 pm

I use Eagle1 from Manu Exposito.
It's very easy and very fast for work with MySQL.

Best regards.

Carlos.
csincuir
 
Posts: 411
Joined: Sat Feb 03, 2007 6:36 am
Location: Guatemala

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

Postby Jack » Sat Feb 25, 2012 5:19 pm

Enrico,
What about the connection string with ADO .
Could you post a sample .

Should we install an ODBC driver and define something in the control pannel ??

Thanks .
Jack
 
Posts: 288
Joined: Wed Jul 11, 2007 11:06 am

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

Postby Rick Lipkin » Sat Feb 25, 2012 6:06 pm

Jack

Here is some info

MySQL OLEDB
Type OLE DB Provider
Usage Provider=MySQLProv
Manufacturer MySQL
Set example values »

More about this provider »
Standard
Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;

http://connectionstrings.com/mysql

You still have to find the oledb client ..

Rick Lipkin
User avatar
Rick Lipkin
 
Posts: 2666
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA

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

Postby Enrico Maria Giordano » Sat Feb 25, 2012 6:34 pm

Jack wrote:Enrico,
What about the connection string with ADO .
Could you post a sample .


This is what I'm using:

Code: Select all  Expand view  RUN
Driver={MySQL ODBC 5.1 Driver};Server=IP address;Database=database name;UID=userid;Password=password;Option=133121


Jack wrote:Should we install an ODBC driver and define something in the control pannel ??


For MySQL you have to install the ODBC connector:

http://www.mysql.it/downloads/connector/odbc

EMG
User avatar
Enrico Maria Giordano
 
Posts: 8725
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia

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

Postby ukservice » Sat Feb 25, 2012 6:45 pm

Hello,

Enrico, where can I find more info about ADO and Harbour?.

Is there a book or e-book?.

Thanks. I am lost
FWH 11.11, Harbour 3.1 and Borland C++ 5.82
User avatar
ukservice
 
Posts: 417
Joined: Tue Feb 23, 2010 3:09 pm
Location: John

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

Postby Enrico Maria Giordano » Sat Feb 25, 2012 6:56 pm

ADO is not tied to a specifical compiler. It's one of the Microsoft framework for connecting to a database engine. You can find the ADO documentation on MSDN:

http://msdn.microsoft.com/en-us/library/windows/desktop/ms675532(v=vs.85).aspx

Try also:

http://www.w3schools.com/ado/default.asp

EMG
User avatar
Enrico Maria Giordano
 
Posts: 8725
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia

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

Postby Rick Lipkin » Sat Feb 25, 2012 7:42 pm

User avatar
Rick Lipkin
 
Posts: 2666
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA

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

Postby mosh1 » Sun Jul 08, 2012 2:44 pm

dutch wrote:Dear All,

I would like to know, the best way to move to MySql?
TMySql (LibMySql)
TDolphin
ADO
etc.

Thanks for all idea and recommendation.

Regards,
Dutch


Where is TMySql?
mosh1
 
Posts: 129
Joined: Sun Oct 09, 2011 3:50 pm

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

Postby DevBr » Sun Jul 08, 2012 4:10 pm

TDolphin,

Simples, Fast and Easy to use. better solucion for MySQL.
DevBr
 
Posts: 13
Joined: Mon Apr 23, 2012 7:43 am

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

Postby Armando » Sun Jul 08, 2012 4:13 pm

Friends:

My opinion:

For a new application: ADO, you need to learn 7 commands, yes only seven commands.
If you want move a DBF application to MySql application: TMySql or TDolphin, are the faster way to move.

Regards
SOI, s.a. de c.v.
estbucarm@gmail.com
http://www.soisa.mex.tl/
http://sqlcmd.blogspot.com/
Tel. (722) 174 44 45
Carpe diem quam minimum credula postero
User avatar
Armando
 
Posts: 3242
Joined: Fri Oct 07, 2005 8:20 pm
Location: Toluca, México

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

Postby mosh1 » Sun Jul 08, 2012 9:32 pm

Cannot build dolphin library

# -----------------------------------------------------------------------
# Building dolphin.lib
#
# C COMPILER :BCC
# PRG COMPILER :XHARBOUR
# -----------------------------------------------------------------------
Compiling .\source\prg\tdolpexp.prg
Compiling .\obj\XHARBOUR\BCC\tdolpexp.c
The system cannot find the path specified.
win-make: *** [.\obj\XHARBOUR\BCC\tdolpexp.obj] Error 1
rm .\obj\XHARBOUR\BCC\tdolpexp.c
mosh1
 
Posts: 129
Joined: Sun Oct 09, 2011 3:50 pm

Next

Return to FiveWin for Harbour/xHarbour

Who is online

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