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

[dutch]

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

[ShumingWang]

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

[Enrico Maria Giordano]

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

EMG

[Rick Lipkin]

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

[csincuir]

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

Best regards.

Carlos.

[Jack]

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 .

[Rick Lipkin]

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

[Enrico Maria Giordano]

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

This is what I'm using:

Code: Select all  Expand view

Driver={MySQL ODBC 5.1 Driver};Server=IP address;Database=database name;UID=userid;Password=password;Option=133121

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

[ukservice]

Hello,

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

Is there a book or e-book?.

Thanks. I am lost

[Enrico Maria Giordano]

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

[Rick Lipkin]

xHarbour and Fwh Wiki

http://wiki.fivetechsoft.com/doku.php?id=ado-related_stuffs

Rick

[mosh1]

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?

[DevBr]

TDolphin,

Simples, Fast and Easy to use. better solucion for MySQL.

[Armando]

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

[mosh1]

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