Fwh used for Prestashop shopcard (SOLVED)

[Marc Venken]

Hey,

Does anyone used FWH for connecting to the popular shopcard Prestashop ?

I'm looking into connecting to it so I could stop using the import functions of Prestashop.
and change stuff directly.

I can read/open the files with phpMyAdmin, so it can be opend for sure with FWH and SQL

I didn't read into the differences yet like : SQL or ADO or Dolphin .... used be several in this forum.

The fact is that I will use Xbrowse as master data manipulation.

Any starting tips for with i should use ?

My level of programming is rather low , so I could go for SQL since I use this also in some php programs.

[Antonio Linares]

Marc,

FWH already provide a built-in MySQL/MariaDB capabilities. You don't need any extra library.

Please review the docs:
viewtopic.php?f=3&t=33286&start=0

[Marc Venken]

Antonio,

I read some posts, and some speek of linking extra lib's (mayby fwh libs ?)

Also installing : mysql-connector-odbc-5.3.7-win32.msi came as a solution. (did install it)

Should I include something extra ?

Now I have these. I even think that i don't need all these includes...

#include "FiveWin.ch"
#include "report.ch"
#include "hbcompat.ch"
#include 'ord.ch'
#include "XBrowse.Ch"
#include "fileio.ch"


this code give a error. Should I activate some ODBC or so ?

Code: Select all | Expand

function Presta()

   local oCn, oRs

   local cServer     := "http://www.kaboutersopglabbeek.be/"
   local cDataBase   := "mydatabasename"
   local cUser       := "myusername"
   local cPassWord   := "mypaswoord"


   ? "Start"
   oCn   := FW_OpenAdoConnection( { "MYSQL", cServer, cDataBase, cUser, cPassword }, .t. )
   if oCn == nil
      ? "Connection Fail"
      return nil
   else
      ? "Connected"
   endif

   oRs   := FW_OpenRecordSet( oCn, "ploegen2006" )
   XBROWSER oRs
   oRs:Close()
   oCn:Close()

return nil

 

[Antonio Linares]

Marc,

Just using

#include "FiveWin.ch"

compiles fine here.

I get the same error as you. We are reviewing it

[nageswaragunupudi]

For MySql ADO to work, you need to download MySql ODBC connector from MySql site and install the msi file. Mr Marc Venken says he did it, but it appears not. He may please reinstall by way of caution.

Only #include "fivewin.ch" is enough.

Also please make sure that the server name, etc are correct.

If you have latest FWH versions, you do not need to do any of these things.

Just use FWH directly, without installing anything.
You may run this in fwh\samples\ folder

Code: Select all | Expand

FWCONNECT oCn HOST cServer USER cUser PASSWORD cPassword DATABASE cDatabase
if oCn == nil
   ? "Failed to connect"
   return nil
else
   ? "Connected"
endif

oRs := oCn:RowSet( "ploegen2006" )
XBROWSER oRs
 

Important:
Please also let us know the FWH version you are using and ODBC connector version you download and install

[Marc Venken]

This version i have installed (instal with no errors, but I don't see if something changed)

mysql-connector-odbc-5.3.7-win32.msi

It was a link from your post somewhere on the forum.

The FWH version is : 16.11

Antonio has the same error on his system?

[nageswaragunupudi]

Antonio has the same error on his system?

That was because he did not install the connector.

If you are using 16.11, my sample should work, if the credentials (server name, etc ) are correct. You did not indicate the port number. Please make sure about port number also.

Please build and run the sample I provided in fwh\samples folder or copy \fwh\dll\libmysql.dll to your exe folder.

[Marc Venken]

Running the sample in de samples folder of FWH .AND. using the buildh.bat file did it working.

Version 16.11 does not need the : mysql-connector-odbc-5.3.7-win32.msi to be installed as far as i see.

It seems that my build file and Mak file is not good, not linking all needed stuff? Have to look into it

[Antonio Linares]

Marc,

There are many makefiles examples in these forums

Search here for makefile

[Silvio.Falconi]

this feature I need also
a question I can use th esql archive of Prestashop directly on fw application or we must to converte on dbf and the reconverte into sql databse ?
I wish create a application because customer ask me th epossibility to change on local the clients,products,and print the order make on prestashop
I ask the gurus to make a teacher guide to use fwh and preestashop .Thanks