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
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.
5) Download and install the connector "mysql-connector-odbc-3.51.27-win32.msi".
Don't create ANY DSN!
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 hbbin.lib
8) Run it and ENJOY!!
====================================
--- Dada Music Movement, tutta la musica che vuoi! ---
_______________________________________________ Harbour mailing list Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour