|
| Iniciado por guest, 29,ene. 2018 20:18 - 5 respuestas |
| |
| | | |
|
| |
| Publicado el 29,enero 2018 - 20:18 |
Hi All
What is the connection string syntax for MySQL in WX?
What driver do I use? The native one? If so, does it have to be purchased?
Cheers
André |
| |
| |
| | | |
|
| | |
| |
| Publicado el 29,enero 2018 - 20:42 |
Hi André,
I don't remember anything special about the connection string and mysql (but I'm not using that very often, so don't take may word for it)
Native driver, yes, definitely (plus the mysql client dkk, of course)
Native driver for mysql is free... just download it from windev.com.
Now, why do you want to use mysql?
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 29,enero 2018 - 21:30 |
There you go, eg:
// just donwload native driver from pcSoft, it's free
// and of course, you can use ODBC and port # 3306 for public access and
// none for intranet
HDescribeConnection("myConn,"username","password","yourIP","mySqlName", hNativeAccessMySQL, hOReadWrite)
HOpenConnection("myConn")
HChangeConnection("myTableInSql", "myConn")
//.. use H...
HCloseConnection("myConn")
HTH
King |
| |
| |
| | | |
|
| | |
| |
| Publicado el 29,enero 2018 - 22:03 |
Hi Fabrice
I am writing sms messages directly into a carrier database. So not my choice of database.
André |
| |
| |
| | | |
|
| | |
| |
| Publicado el 29,enero 2018 - 22:05 |
Hi King
Thanks - they are using a non standard port though. I will place this in the additional information.
André |
| |
| |
| | | |
|
| | |
| |
| Publicado el 30,enero 2018 - 12:35 |
Hi André,
I see, and I'm very surprised that they let you write remotely into a mysql DB... Sounds like a very good way of being hacked... I'm surprised they are not offering you a webservice access instead. Most sms provider I've seen have a simple URL to use for that.
Best regards |
| |
| |
| | | |
|
| | | | |
| | |
|