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

Reply via email to