Connecting to a mysql server on a VPS
lazarus / 16-Databases

----------------------------------------------------------------------
Robert.Thompson · 2018-12-28 22:36

Hello:

Is it possible to have my desktop lazarus program connect to a mysql
database living on a Digital Oceans droplet?

Pardon the poor terminology but, if the above is possible, I think
that would be more at my skill-level to build a desktop application
that gets, saves and shares only data to a VPS.

Am I correct? I would distribute my lazarus exe and everyone
would/could connect to the data on the VPS.

Any thoughts would be greatly appreciated.

Rob.

----------------------------------------------------------------------
lucamar · 2018-12-28 22:46

Theorically, provided the connection is (or can be made) sanely done
and the DB server/client allow the protocol used or can tunnel through
it then yes.

----------------------------------------------------------------------
Robert.Thompson · 2018-12-29 17:04

Hello:

I found this post:

http://forum.lazarus.freepascal.org/index.php?topic=3287.0

Does anyone know how to create the required “system-DSN” on linux
(mint)?

I installed unixodbc-dev unixodbc-bin and unixodbc but ODBCConfig does
not launch the ‘manager’.

Any suggestions?

Thanks,

Rob.

----------------------------------------------------------------------
sash · 2018-12-29 17:58

I don't exactly know what a "Digital Oceans droplet" is, but a regular
VPS is a simply another machine, and all you have to do is to
configure mysql server to accept incoming connections on external
network interface.

And for a Lazarus-based MySQL client application a usage of ODBC is
redundant.

----------------------------------------------------------------------
lucamar · 2018-12-29 18:27

Quote from: sash on December 29, 2018, 06:58:42 pmI don't exactly know
what a "Digital Oceans droplet" is [...]
Basically, virtual machines in "the Cloud". More info/hype:
Droplets on DigitalOcean - More than just virtual machines