New corrected version.
MINI-TUTORIAL TO CONNECT HARBOUR PROGRAM WITH MYSQL DB
Here's my little and nice tutorial about connection
between a local Harbour program AND a remote MySQL Database.
by GIOVANNI DI MARIA (many tanks to Massimo Belgrano for his help)
Follow the following steps:
====================================
1) You need a mysql server (local or remote).
I use the remote service www.db4free.net.
2) Create the database on the server.
3) Create the table on this database.
4) Create some column on this table.
4a) If you want add some record.
5) Download and install the connector "mysql-connector-odbc-3.51.27-win32.msi".
Don't create ANY DSN! I have problem with new connector version 5.
6) Write and compile the following harbour program:
#include "adordd.ch"
REQUEST ADORDD
function Main()
clear screen
setmode(25,80)
USE DatabaseName VIA "ADORDD" TABLE "TableName" MYSQL FROM "db4free.net" USER "username" PASSWORD "password"
dbedit()
USE
clear screen
return nil
7) Compile it with hbmk2 program.prg rddado.lib hbwin.lib
8) Run it and ENJOY!!
====================================
--- Dada Music Movement, tutta la musica che vuoi! ---
_______________________________________________ Harbour mailing list [email protected] http://lists.harbour-project.org/mailman/listinfo/harbour
