LiveCode Forums

I would like to ask how can I get data/database from Microsoft SQL Server to LiveCode as Im currently building a User LogIn Registration part of an app, in terms of getting user's username, password, phone num & email address. Thx

Hi Adrian,

welcome to the forum!
I moved this thread to the correct forum (Hint, hint!), since this is really no announcement!


Best

Klaus

adrianyong wrote: ↑

Fri Jan 04, 2019 10:52 am

I would like to ask how can I get data/database from Microsoft SQL Server to LiveCode as Im currently building a User LogIn Registration part of an app, in terms of getting user's username, password, phone num & email address. Thx

yes you can access a MS Sql server from Livecode. By using the "odbc" method of connection.

Search the forum.

For instance :

viewtopic.php?f=12&t=31915

You can also find a lot of information about it on Max's excellent Wiki.

Unless the app is carefully restricted to work only within your local network, you will not want your app to connect to the database directly, as that would require exposing your database to the open Internet. Your client app will instead make HTTP calls to an API on the server which then connects to the database locally on that server.

You can craft your HTTP API in LiveCode Server, or PHP, Perl, Python, or any other scripting language suitable for server work.

When PHP is used in that role, generically the setup is referred to as LAMP (Linux, Apache, MySQL, PHP), and there are innumerable tutorials available around the web on setting that up.

To use LiveCode Server in that role, these lessons will be helpful:
http://lessons.livecode.com/m/4070