FiveTech Software tech support forums

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 .

This is what I'm using:

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

Hello,

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

Is there a book or e-book?.

Thanks. I am lost

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 ... s.85).aspx

Try also:

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

EMG

xHarbour and Fwh Wiki

http://wiki.fivetechsoft.com/doku.php?i ... ted_stuffs

Rick

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?

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