|
FORUMS PROFESSIONNELS WINDEV, WEBDEV et WINDEV Mobile |
| | | | | |
[WM] Connecting to MySql DB |
Débuté par Mike Allison, 23 jan. 2010 23:29 - 11 réponses |
| |
| | | |
|
| |
Posté le 23 janvier 2010 - 23:29 |
Hi Guys, We currently use .NET for our software that sits on Hand Held Terminals (WinCE). We have a little prog from Corelab (now Devart) which works very well. We are interested in moving to Windev Mobile but need to link by wireless to our MySQL DB. Has anybody done this or does anybody know of a connector (like the LibmySQL.dll) that we can use to try. Any assistance is appreciated. Many Thanks. Mike Allison |
| |
| |
| | | |
|
| | |
| |
Posté le 24 janvier 2010 - 10:35 |
Hi, You'd most likely use RDP to connect to your server. Or you could create a web service that connects to MySQL and your PDA would connect to the web service. If you've lost connection to the web service, you could then store your data locally. And then next time you connect back to the webservice, you could then upload your data. I'm presently doing this using MSSQL, and have the hooks in to easily switch over to MySQL. If you need any further info, don't hesitate to ask. |
| |
| |
| | | |
|
| | |
| |
Posté le 24 janvier 2010 - 16:45 |
Hello
>Or you could create a web service that connects to MySQL and your PDA would connect to the web service. If you've lost connection to the web service, you could then store your data locally. And then next time you connect back to the webservice, you could then upload your data.
i use this option for 4 years on MSSQL , mySQL, PostGreSQL, Oracle, Firebird with php4wd the mobile use wifi or gprs to join the script php. the script do the SQL query on the DataBase server and send the data to the mobile. also if you want security you can use with this the HTTPS protocol without changing anything in the code see : http://www.sqlmanagerx.com/websqlx/html/modules/icontent/index.php… best regards |
| |
| |
| | | |
|
| | |
| |
Posté le 25 janvier 2010 - 11:51 |
Guys, Thanks for the responses. Not sure how I would do it based on your responses. The DB normally sits on a Windows Server or an XP Box with MySql on it. Currently we have no issues because the HHT connects to the Wireless Lan and thinks that it is just another connection to the network. With what you are suggesting, if I understand correctly, then we have to go down the web route. With our environment, if the WLAN is down, then nothing works and we are happy with that situation. Mike Allison |
| |
| |
| | | |
|
| | |
| |
Posté le 25 janvier 2010 - 14:19 |
Firetox, Thanks for your reply. I have had a look at the sqlmanager website. It is all in french so I am a bit stuck with it. Do you have an "idiot guide" (simple setup) that I can have a look at to see how it links into a windev mobile app. Also, what price are we talking about (I assume it is not for free). Mike Allison |
| |
| |
| | | |
|
| | |
| |
Posté le 25 janvier 2010 - 14:19 |
hello mike
>Also, what price are we talking about (I assume it is not for free).
all of SQLManagerX and native acces are free and rela free my englisjh is poor but i cant translate some infomartions for you like post on the forum if you post a question (in english) you have response in english. i cant help you to undestand the idea and have a an example to work (like david Egan whose have some contact with us) for begenning get the php4D project to hace class and script then lokk script (connect.php) becaus all other script are not to be modified the you have to insert the class php4wd.wdc in your project (for mobile project you must take care to the member : PocketPC : it's use for in mode test with pc (false value) end for mobile execution (ture value) the for explain with example : put the script (connect.php, php4wd.ph , pkzip.php) on your web space change the key in connect.php and (all the connexion member like host, pass, user) to connect to you data base (like a web site in php) then in you project windev you have to ths insert the class in you project in a button or project int the code like
myAccess is c_Php4WD() myAccess:TypeBase= "MYSQL" myAcces::CleCryptage = "AABBCCDDFF" v_retCode = myAcces:mySQLConnecte("http://127.0.0.1/php4wd.php","","","FREDERIC") IF not (v_retCode = True) THEN Erreur("Impossible to do the connexion .", "Error n° " + monAccess:mySQLErreur, myAccess:mySQLGetErrorMessage()) END then afeter you cant use MySQLexec for executing query for example
retCode = myAccess:mySQLExec("SELECT work_list, lnotes FROM work_list",0) IF (retCode=1) THEN myAccess:mySQLPremier(0) WHILE (NOT monAccess:mySQLEnDehors) Trace(myAccess:mySQLCol(0,1)+ "| "+ yAccess:mySQLCol(0,2)) myAccess:mySQLSuivant(0) END ELSE Erreur("Erreur n° " + myAccess:mySQLErreur, myAccess:mySQLGetErrorMessage()) END myAccess:mySQLFerme(0) if this is ok then you can do what you want Best regards Firetox |
| |
| |
| | | |
|
| | |
| |
Posté le 25 janvier 2010 - 14:21 |
Hello all is free and with can help you with the forum but we can do that for prestation Emidev is a compagny witch have created all SQLManagerX item and use them every day then we have experience on using it) the SQLManagerX and forum are free but if you want help rapidly and custom on your project we can help ypou with customer sevice. but like david egan whose demand some modification on MSSQL4WD for free generaly the SQLManagerX user can have solution on themself with only some questions on the forum (you can support them on the site with donate but in 10 years french have donate nothing !!!) then you can realise that SQLManagerX is not created for money because i continue to support it for free (sorry for my poor english) Best regards FireTox |
| |
| |
| | | |
|
| | |
| |
Posté le 26 janvier 2010 - 11:30 |
Hi Firetox, Many thanks for your help. As you may have guessed, my French is not so good (I sometimes have trouble with english!). Do you, or anybody else, have a quick sample project that we can try - just to get the feel of how things work. I always find it a bit easier if there is something I can work through and then add bits myself so that I get the full feel of what it is doing. Many thanks again. Mike Allison |
| |
| |
| | | |
|
| | |
| |
Posté le 27 janvier 2010 - 18:54 |
David, Thanks for the info. Will you be around as I am bound to make a complete hash of it. I have always tried to stay away from external dll's because I have found the help to be rather poor. I am one of those who likes to see it working in a demo mode so that I can fiddle with it to see how it works. Thanks again, Mike Allison |
| |
| |
| | | |
|
| | |
| |
Posté le 07 mai 2015 - 11:37 |
| |
| |
| | | |
|
| | |
| |
Posté le 17 juin 2017 - 09:30 |
| |
| |
| | | |
|
| | |
| |
Posté le 10 janvier 2018 - 01:51 |
FireTox, you´re the creator of php4wd ?
There are some examples for Insert, Delete , Update ? Or use the sqlserver transact/sql is ok ?
Thank you ! |
| |
| |
| | | |
|
| | | | |
| | |
| | |
| |
|
|
|