Fivewin/xharbour with ActiveX Data Objects (ado) and MySQL
Posted: Thu Jan 29, 2015 4:03 pm
Hello,
I want to make a CRUD application (Create, Retrieve, Updata, Delete) with Fivewin 2015/Xharbour, ActiveX Data Objects (ado) and MySQL.
I make this post because of the recommendation of Antonio to make use of ado. See topic viewtopic.php?f=3&t=30066
In that post one can download https://bitbucket.org/fivetech/fivewin- ... 140730.zip. (First I tried to establish a connection with testsql1.prg).
My goal of this post is to get a good understanding of how diferent technologies work together (Fivewin, xharbour, ado, mysql etc.) and to make a little application (crudapp.prg).
The goal above is a subgoal of general goal: To find possible solutions based on SQL for an existing software program, which now uses .dbf technology and Advantage Database Server (Ads). (Later I will probably give more information and ask some advice about this general goal in a new topic).
First I give an overview of alle the technologies I use.
-Windows 8.1 (64 bit) on a virtual machine (virtualbox)
-Fivewin 2015
-xHarbour 1.2.3 Intl. (SimpLex) (Build 20141106)
-Borland 5.5 compiler
-MySQL Server 5.6.22 (also with ODBC 5.3.4 connector for MySQL)
Directory structure is:
C:\Borland\BCC55 (borland compiler)
C:\fwh (fivewin 2015)
C:\xHarbour (Xharbour compiler)
C:\Dev\crudapp (In this directory I will make the application crudapp.prg)
C:\Dev\fivedbu (In this directory I wil try to get fivedbu.prg working, which comes from the fivewin 2015 libraries samples or from https://bitbucket.org/fivetech/fivewin- ... 140730.zip)
-I make use of .bat file located in C:\Dev which is a little adjustment of the original buildx.prg from the fivewin 2015 library (For eample: if "%FWDIR%" == "" set FWDIR=c:\fwh instead of if "%FWDIR%" == "" set FWDIR=.\..\ etc.)
Questions:
-Does it matter if I use fivedbu.prg from the samples in fivewin 2015 library or https://bitbucket.org/fivetech/fivewin- ... 140730.zip? (maybe some differences?)
-I get an error when I compile fivedbu.prg (copied file from c:\fwh\samples to c:\dev\fivedbu): Error fivedbu.RC 4 8: Cannot open file: WinXP/WindowsXp.Manifest *Linking errors* (how to solve this?)
-In fivedbu_20140730 directory I get the error (from .zip): fivedbu.prg(665) Error E0067 TRY section requires a CATCH or FINALLY handler
There is also something with a resource file (.rc), I do not understand exactly how that works.
Kind regards,
Pieter
I want to make a CRUD application (Create, Retrieve, Updata, Delete) with Fivewin 2015/Xharbour, ActiveX Data Objects (ado) and MySQL.
I make this post because of the recommendation of Antonio to make use of ado. See topic viewtopic.php?f=3&t=30066
In that post one can download https://bitbucket.org/fivetech/fivewin- ... 140730.zip. (First I tried to establish a connection with testsql1.prg).
My goal of this post is to get a good understanding of how diferent technologies work together (Fivewin, xharbour, ado, mysql etc.) and to make a little application (crudapp.prg).
The goal above is a subgoal of general goal: To find possible solutions based on SQL for an existing software program, which now uses .dbf technology and Advantage Database Server (Ads). (Later I will probably give more information and ask some advice about this general goal in a new topic).
First I give an overview of alle the technologies I use.
-Windows 8.1 (64 bit) on a virtual machine (virtualbox)
-Fivewin 2015
-xHarbour 1.2.3 Intl. (SimpLex) (Build 20141106)
-Borland 5.5 compiler
-MySQL Server 5.6.22 (also with ODBC 5.3.4 connector for MySQL)
Directory structure is:
C:\Borland\BCC55 (borland compiler)
C:\fwh (fivewin 2015)
C:\xHarbour (Xharbour compiler)
C:\Dev\crudapp (In this directory I will make the application crudapp.prg)
C:\Dev\fivedbu (In this directory I wil try to get fivedbu.prg working, which comes from the fivewin 2015 libraries samples or from https://bitbucket.org/fivetech/fivewin- ... 140730.zip)
-I make use of .bat file located in C:\Dev which is a little adjustment of the original buildx.prg from the fivewin 2015 library (For eample: if "%FWDIR%" == "" set FWDIR=c:\fwh instead of if "%FWDIR%" == "" set FWDIR=.\..\ etc.)
Questions:
-Does it matter if I use fivedbu.prg from the samples in fivewin 2015 library or https://bitbucket.org/fivetech/fivewin- ... 140730.zip? (maybe some differences?)
-I get an error when I compile fivedbu.prg (copied file from c:\fwh\samples to c:\dev\fivedbu): Error fivedbu.RC 4 8: Cannot open file: WinXP/WindowsXp.Manifest *Linking errors* (how to solve this?)
-In fivedbu_20140730 directory I get the error (from .zip): fivedbu.prg(665) Error E0067 TRY section requires a CATCH or FINALLY handler
There is also something with a resource file (.rc), I do not understand exactly how that works.
Kind regards,
Pieter