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

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

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

EMG

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

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

Best regards.

Carlos.

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

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

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

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 ??

Hello,

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

Is there a book or e-book?.

Thanks. I am lost

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

TDolphin,

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

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

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